Max, Min, Average (excel 2003)

Please see attached.  Have column A with Product Type and Column B with Cost.  Need to obtain max, min, average per product.  Need to present it in cells E5:G6.

Thanks,
JP Max-min-avg.xls a
easycapitalAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jppintoConnect With a Mentor Commented:
Here you go...please check the attached solution...

jppinto
Max-min-avg-1-.xls
0
 
jppintoCommented:
Please note that I've used array formulas that need to be entered by using Ctrl+Shift+Enter (the brackets should appear after the enter).
0
 
barry houdiniConnect With a Mentor Commented:
Hello JP,

You can use "array formulas" for this, e.g. in E5 use this formula

=MAX(IF($A$3:$A$9=$D5,$B$3:$B$9))

confirmed with CTRL+SHIFT+ENTER and copied to E6

Then identical in F5:G6 but with MIN/AVERAGE instead of MAX

see attached

regards, barry
26903135.xls
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
barry houdiniCommented:
....sorry JP, didn't see your reply......
0
 
jppintoCommented:
No problem Barry, it happens to all of us... :)
0
 
easycapitalAuthor Commented:
Excellent!
One comment though. When I used the "IF" formula and used 0 for the false, the results were not always right.  Any thoughts.
Thanks,
JP
0
 
easycapitalAuthor Commented:
So I used the formula just as indicated without the zero, but I just thought it was good to point out the results.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.