Need max of a range that meets criteria like SUMIF. Have dropdown selecting month and strand from daily data. For summary need max of field that meets the criteria.
Need max of a range that meets criteria like SUMIF. Have dropdown selecting month and strand from daily data. For summary need max of field that meets the criteria.
How about =if(Critera_Test, then Max(), else nothing) an example sheet would help...
I am sending a spreadsheet. The selection criteria and the data. I need the max of Data column P when Column D = SelectionCriteria K3. The drop down boxes change K3.Example.xlsx
Last edited by catsmith; 03-05-2013 at 10:35 PM. Reason: Correction
Take a look at the attached and see if it gives you what you need.
The formula is an array formula so if you edit it be sure to hold down crtl+shift and then press enter. If it worked the formula will have { } around it in the formula bar.
Good Luck and I hope this helps.
Tom
That worked thank you very much. One more question please.
When I typed in the formula it did not work I have to copy yours and edit. How do you create an array formula?
Did you use the ctrl+shift+enter after you typed in the formula? That makes it an array formula.
Hope this helps
Tom
Last edited by Tank997; 03-05-2013 at 11:39 PM.
yes thanks again. I got it to work now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks