G
goss
Hi all -
I need to find the average of 12 noncontigouse cells
Each cell to be included only if the value of the cell is > 0
If these cell were contigous I could use a sumif/countif formula
Not sure how to proceed for noncontiguous
These cells for example
=+L11+R11+W11+AB11+AH11+AM11+AR11+AX11+BC11+BH11+BN11+BQ11
Thx
Best regards,
-markc
I need to find the average of 12 noncontigouse cells
Each cell to be included only if the value of the cell is > 0
If these cell were contigous I could use a sumif/countif formula
Not sure how to proceed for noncontiguous
These cells for example
=+L11+R11+W11+AB11+AH11+AM11+AR11+AX11+BC11+BH11+BN11+BQ11
Thx
Best regards,
-markc