Hi guys,
I hope you might be able to help me figure out why my formula isn't working. Here is a screen cap of what is happening.
http://i.imgur.com/LMyK9vh.png
The formula in X6613 is =MAX(IF((FirstHb<>"u")*(UnitsTransfused=0),W$2:W$6594,0))
But you can see in the filtered results that clearly there are only 5 results for people not transfused and the max value should actually be 12.7. What am I missing here?
thanks in advance!
I hope you might be able to help me figure out why my formula isn't working. Here is a screen cap of what is happening.
http://i.imgur.com/LMyK9vh.png
The formula in X6613 is =MAX(IF((FirstHb<>"u")*(UnitsTransfused=0),W$2:W$6594,0))
But you can see in the filtered results that clearly there are only 5 results for people not transfused and the max value should actually be 12.7. What am I missing here?
thanks in advance!