| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a MAXIF formula similar to the SUMIF formula?
For a year in F2 (e.g. 2000) and month in G2 (e.g. 1) =MAX(IF(($A$2:$A$1000=F2)*($B$2:$B$1000=G2),$E$2:$ E$1000)) confirmed with CTRL+SHIFT+ENTER enter all your year month combinations in columns F and G and copy formula down -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=521250 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel whilst using the sumif formula to search for part of a word | Excel Discussion (Misc queries) | |||
| SumIf formula with complex criteria | New Users to Excel | |||
| Modifyiing a SumIF Formula to look for "OLA* | Excel Worksheet Functions | |||
| How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
| Formula help SUM(IF((... | Excel Worksheet Functions | |||
Threaded Mode
