My dear,with best regards,asking you kindly to help me to find the average price of the codes mentioned in attacced file.
Thanking in advance.
My dear,with best regards,asking you kindly to help me to find the average price of the codes mentioned in attacced file.
Thanking in advance.
Hi,
use something like =AVERAGE(IF($c$5:$c$25="a",$b$5:$b$25,0)) in G5 entered as an array formula
adapt your formula to the other conditions
Last edited by arthurbr; 10-22-2008 at 09:36 AM.
Put this in G5 and drag down:Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Using your posted workbook...
This regular formula returns the average price for Code="A"
Copy that formula down as far as you need.Please Login or Register to view this content.
With your sample data, these values are returned:
Does that help?Please Login or Register to view this content.
=AVERAGE(IF($c$5:$c$25="a",$b$5:$b$25,false)) ( sorry, mistake)
Enter with Ctrl+Shift+Enter
many thanks to all experts for their solutions
If your problem is solved, don't forget to adapt your thread title prefix !
My dear,with regards,asking your goodselves about(how can i find the latest price from the enclosed schedule for each code?)
Thanking you very much for your co-opration.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks