Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maxif equivalent
I have a sumif formula, as in:
=sumif(I:I,a2,J:J) I also want to calculate the maximum of the values which meet the criteria. Is this possible? -- Regards, Fred |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maxif equivalent
From an earlier post of mine today. Note NOT using on complete columns
try this array formula which must be entered using ctrl+shift+enter =MAX(IF(A2:A22="mytruckcode",B2:B22)) or =MAX(IF(A2:A22=c2,B2:B22)) -- Don Guillett SalesAid Software "Fred Smith" wrote in message ... I have a sumif formula, as in: =sumif(I:I,a2,J:J) I also want to calculate the maximum of the values which meet the criteria. Is this possible? -- Regards, Fred |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maxif equivalent
Try something like this, array-entered (press CTRL+SHIFT+ENTER):
=MAX(IF(I1:I100=A2,J1:J100)) Entire col references cannot be used -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Fred Smith" wrote in message ... I have a sumif formula, as in: =sumif(I:I,a2,J:J) I also want to calculate the maximum of the values which meet the criteria. Is this possible? -- Regards, Fred |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maxif equivalent
Thanks guys.
I was hoping to avoid arrays, and use the entire column reference, but c'est la vie. Perhaps in a future version of Excel. Your recommendation works perfectly. -- Regards, Fred "Max" wrote in message ... Try something like this, array-entered (press CTRL+SHIFT+ENTER): =MAX(IF(I1:I100=A2,J1:J100)) Entire col references cannot be used -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Fred Smith" wrote in message ... I have a sumif formula, as in: =sumif(I:I,a2,J:J) I also want to calculate the maximum of the values which meet the criteria. Is this possible? -- Regards, Fred |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maxif equivalent
You're welcome, Fred.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Fred Smith" wrote in message ... Thanks guys. I was hoping to avoid arrays, and use the entire column reference, but c'est la vie. Perhaps in a future version of Excel. Your recommendation works perfectly. -- Regards, Fred |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maxif equivalent
=SUMPRODUCT(MAX((I1:I100=A2)*J1:J100))
"Fred Smith" wrote: I have a sumif formula, as in: =sumif(I:I,a2,J:J) I also want to calculate the maximum of the values which meet the criteria. Is this possible? -- Regards, Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WORKDAY() Function Equivalent with SUMPRODUCT() | Excel Worksheet Functions | |||
HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)? | Excel Worksheet Functions | |||
Can you convert a number to word equivalent ? | Excel Worksheet Functions | |||
MaxIF instead of SumIF | Excel Discussion (Misc queries) | |||
maxif | Excel Worksheet Functions |