Hi,
You can use SUMIF and COUNTIF to do this. Thus:
=SUMIF(A1:B12,"a",B1:B12)/COUNTIF(A1:A12,"a")
...will give you the average for the a's.
HTH,
SamuelT
Hi,
You can use SUMIF and COUNTIF to do this. Thus:
=SUMIF(A1:B12,"a",B1:B12)/COUNTIF(A1:A12,"a")
...will give you the average for the a's.
HTH,
SamuelT
Last edited by SamuelT; 01-09-2007 at 08:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks