| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a MAXIF formula similar to the SUMIF formula?
I have a worksheet similar to the following:
A B C D E Year Month Day Hour Value 2000 1 15 2000 1 20 2000 1 11 2000 2 18 2000 2 3 2000 2 30 2000 3 14 2000 3 5 2000 3 6 The worksheet continues on including values for every hour of every day until the present time. I want to summarize on another worksheet the maximum value in column E for each month for each year. Year/Month 1 2 3 2000 2001 2002 Any suggestions? |
| 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
