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.