G
Guest
Hello everyone,
I was wondering if there was a way of excluding Zero’s from averages.
I have tried IF and AND but have not been able to get it to work correctly.
I want to be able to fist find column b, then get an average by group where
value in F is not Zero.
This is what I have (it's working, but I can’t seem to be able to count only
if value <> 0, using a countif)
=(SUMIF(B18:B65536,B8,F18:F72))/COUNTIF(B18:B65536,B8)
Sample data:
B C E F G H
Online Sales 329 138 1 150 1
Location Sales 999 18 2 130 1
Thanks
I was wondering if there was a way of excluding Zero’s from averages.
I have tried IF and AND but have not been able to get it to work correctly.
I want to be able to fist find column b, then get an average by group where
value in F is not Zero.
This is what I have (it's working, but I can’t seem to be able to count only
if value <> 0, using a countif)
=(SUMIF(B18:B65536,B8,F18:F72))/COUNTIF(B18:B65536,B8)
Sample data:
B C E F G H
Online Sales 329 138 1 150 1
Location Sales 999 18 2 130 1
Thanks