Excel: failing with MAX and IFs

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!

This question generated 8 answers. To proceed to the answers, click here.

This thread is current as of August 15, 2015.

For more resources for Microsoft Excel