IF statement doesn't work as expected

Hello everybody,

I have a problem with this statement =MAX(IF(($C$8:$C$13=$D2);$D$8:$D$13)) that return the VALUE! error.

My need is to search for the MAX value only of some Rows (rows that has Owner="Mary" and not Owner="Tony" or "Jack").

Any idea ?

Thanks,
ilao

Hey ilao,

Could you type a small sample of your data? It is hard to help without seeing it exactly.

This is an array formula, so when you have finished editing you need to press Ctrl-Shift-Enter to make it work.

Are you ENTER the formula correctly? That's array formula, can not ENTER alone, you need press/hit all together CTRL+SHIFT+ENTER button...

I agree that it is an Array, but his formula might not solve identifying the correct owner.

A sample (not with Owner but with numbers) is the following. My Expected result is "7", that is the MAX of value with "3" as TAG. Additionally this information: the Function (Fx) Popup Windows correctly shows me "7" as final result, but in the cell the VALUE! error is displayed...



#VALUE! 3


3 3,00
2 4,00
3 5,00
4 6,00
3 7,00
4 8,00

Sample.jpgSample.jpg

This is an array formula but the result should be a single scalar value that the pop up Fx window, show me correctly. But finally in the cell an error is displayed....

OK THANKS NOW WORKS. WAS Ctrl-Shift-Enter. I type Ctrl-Shift-Enter in the cell but the right place was in Formula BAR.

Thank you everybody.

Ciao