| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
?How can I find the maximum column with condition
A B C Apple California $10 Orange California $5 Apple Florida $28 Orange Texas $5 Apple California $22 I want a formula that will give me the maximum Apple cost in California. How would I do that? The asnwer should be $22 Thank you in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?How can I find the maximum column with condition
Hi,
One way: =MAX(IF((A1:A10="apple")*(B1:B10="california"),C1: C10)) this is an array formula so enter using Ctrl+Shift+Enter HTH Jean-Guy "SAM SEBAIHI" wrote: A B C Apple California $10 Orange California $5 Apple Florida $28 Orange Texas $5 Apple California $22 I want a formula that will give me the maximum Apple cost in California. How would I do that? The asnwer should be $22 Thank you in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?How can I find the maximum column with condition
WOW!!! That really worked.. Thank you so much Jean...You are awesome!
Pacific Time "pinmaster" wrote in message ... Hi, One way: =MAX(IF((A1:A10="apple")*(B1:B10="california"),C1: C10)) this is an array formula so enter using Ctrl+Shift+Enter HTH Jean-Guy "SAM SEBAIHI" wrote: A B C Apple California $10 Orange California $5 Apple Florida $28 Orange Texas $5 Apple California $22 I want a formula that will give me the maximum Apple cost in California. How would I do that? The asnwer should be $22 Thank you in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?How can I find the maximum column with condition
=SUMPRODUCT(MAX((A1:A5="Apple")*(B1:B5="California ")*(C1:C5))) "SAM SEBAIHI" wrote: A B C Apple California $10 Orange California $5 Apple Florida $28 Orange Texas $5 Apple California $22 I want a formula that will give me the maximum Apple cost in California. How would I do that? The asnwer should be $22 Thank you in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?How can I find the maximum column with condition
Thank you mama :-) "Teethless mama" wrote in message ... =SUMPRODUCT(MAX((A1:A5="Apple")*(B1:B5="California ")*(C1:C5))) "SAM SEBAIHI" wrote: A B C Apple California $10 Orange California $5 Apple Florida $28 Orange Texas $5 Apple California $22 I want a formula that will give me the maximum Apple cost in California. How would I do that? The asnwer should be $22 Thank you in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Tricky 'Find Maximum' problem seeks formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
Linear Mode
