mercredi 19 juillet 2017

Array Median If statement not working

I have a Median If Array formula that brings back one value rather than calculating the median. Below is the formula. I think the issue may be caused by the formula referring to entire columns and not including an if statement related to <>"", but have not been successful figuring out where that would go. Any thoughts are much appreciated!

{=IFERROR(MEDIAN(IF(Raw!$L:$L=$A3,IF(Raw!$B:$B=$D$1,IF($B3="mg/L",Raw!$M:$M,Raw!$N:$N)))),"No Data")}

I want the formula to do the following: "If the common name in A3 matches a value in Raw L, and if the sample station in D1 matches a value in Raw B, and if the units in B3 are "mg/L", then calculate the median of the results in Raw M. Otherwise if the units are not "mg/L, then calculate the median from the results in Column N. If there are no results at all, then state "No Data" in the cell.

Aucun commentaire:

Enregistrer un commentaire