Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise
Yes
=MAX(IF(rng1=some_value,rng2)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. Excel will automatically enclose the formula in braces (curly brackets), do not try to do this manually. When editing the formula, it must again be array-entered. rng1 and rng2 can be the same range or different ranges. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sathya2" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
similar to sumif() but for averages | Excel Discussion (Misc queries) | |||
A formula maxif, similar with sumif or countif | Excel Worksheet Functions | |||
Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
MINIF /MAXIF Or something similar | Excel Discussion (Misc queries) | |||
MaxIF instead of SumIF | Excel Discussion (Misc queries) |