R
rudy
Anyone know if there is averageif type of function similar to sumif?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
daddylonglegs
There isn't a specific single function but in general if you want the
average of B1:B10 when A1:A10 is "xxx" then either
=AVERAGE(IF(A1:A10="xxx",B1:B10))
confirmed with CTRL+SHIFT+ENTER or
=SUMIF(A1:A10,"xxx",B1:B10)/MAX(1,COUNTIF(A1:A10,"xxx"))
which just requires ENTER
average of B1:B10 when A1:A10 is "xxx" then either
=AVERAGE(IF(A1:A10="xxx",B1:B10))
confirmed with CTRL+SHIFT+ENTER or
=SUMIF(A1:A10,"xxx",B1:B10)/MAX(1,COUNTIF(A1:A10,"xxx"))
which just requires ENTER
R
rudy
thanks, I am not familiar with the CTRL+SHIFT+ENTER, what does this do?
A
Ardus Petus
Try SUMIF/COUNTIF
HTH
HTH
P
Peo Sjoblom
Also note that next version of excel will have an averageif function
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
D
daddylonglegs
rudy said:thanks, I am not familiar with the CTRL+SHIFT+ENTER, what does this do?
See Chip Pearson's website for an explanation
http://www.cpearson.com/excel/array.ht