average of 12 noncontiguous cells
But the OP had a condition 0
This is a prime example of a not so good spreadsheet design
Anyway here's an ugly way
=SUM(SUMIF(INDIRECT({"D8","G8","I8","K8","P8","R8" }),"0"))/SUM(COUNTIF(INDIRECT({"D8","G8","I8","K8","P8","R8 "}),"0"))
the OP needs to adapt it to his requirement
--
Regards,
Peo Sjoblom
"Billy Liddel" wrote in message
...
Try this
=AVERAGE(L11,R11,W11,AB11,AH11,AM11,AR11,AX11,BC11 ,BH11,BN11,BQ11)
Peter
"goss" wrote:
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+B N11+BQ11
Thx
Best regards,
-markc
|