I thought "multiple groups" meant you want you wanted Group1 average, Group2
average, etc. After seeing Tom's interpretation, I guess you might want the
average of Group1+Group2, etc.

My formula would have to change to
=AVERAGE(IF((A1:A6={"JB","SL"})*(B1:B6<""),B1:B6) )
where your data is in A1:B6 and "JB", "SL" were the groups I used to test.
Still entered w/CSE.


"JMB" wrote:

Assuming your table is in A1:B6, and A9 = the group you want to average, try:

=AVERAGE(IF((A1:A6=A9)*(B1:B6<""),B1:B6))

entered with Cntrl+Shift+Enter (or you'll get #VALUE!).

"dkingston" wrote:

i have a simple table where column A contains group #s and column B contains
values.
i need to find the average of multiple groups within the table and ignore
rows where the value column is blank. the # of members within each group may
change and i would prefer not to have to sort by group # if that's possible.
thanks in advance for your time.