A
Anto111
Hi,
I have a spreadsheet where I need to sum values based on positional
desigantion within a football team.
For example I need to sum values contained in K7:K34 only for players
designated as C Def in Column B7:B34.
I have been succesful with this using the formula:
=SUMPRODUCT(--(B7:B34="C DEF"),K7:K34)
What I need to do now though is get the average of this sum excluding zero
values and blank cells. I hope I have been clear enough!?
Many thanks in advance.
Ant
I have a spreadsheet where I need to sum values based on positional
desigantion within a football team.
For example I need to sum values contained in K7:K34 only for players
designated as C Def in Column B7:B34.
I have been succesful with this using the formula:
=SUMPRODUCT(--(B7:B34="C DEF"),K7:K34)
What I need to do now though is get the average of this sum excluding zero
values and blank cells. I hope I have been clear enough!?
Many thanks in advance.
Ant