Can we use Max if function

[Arpita_Excel]

Hello Everyone,

How we can make the formula to find out the maximum value in a range on the basis of criteria.

As we use Sumif function to find out the total for the range.

Thanks
Arpita

[NeedForExcel]

You will need something like -

Please Login or Register  to view this content.

- Commit using Ctrl+Shift+Enter

See attached file

[Arpita_Excel]

It works, thanks for the help

[NeedForExcel]

Glad it helped!

[Ace_XL]

Non-array solution

=MAX(INDEX((D2=$A$2:$A$9)*$B$2:$B$9,0),0)