Countifs quesiton

[tuktuk]

I have summary sheet that references values on a data sheet. if the data sheet if populated with a 0 the summary sheets cells show "-".

I want to count all cells that do not contain a "-" on the summary sheet for range ("G5:AD5")

What would the correct formula be for such scenario?

I appreciate it.

Tuk

 

[Scott Huish]

=countif(g5:ad5,"<>-")

If it's just formatted to show the -, then:
=COUNTIF(G5:AD5,"<>0")

 

[Scott T]

If the range actually has zeros in them and the number formatting shows "-" then this should work

=COUNTIF(G5:AD5,"<>0")

If the range actually has "-" in it then this should work

=COUNTIF(G5:AD5,"<>-")

 

[tuktuk]

gotcha.....what if is not a continuous range and individual cells. more specifically: CA5, CC5, CE5....etc?

using the "<>0") option

 

[Scott Huish]

Something like this:

=SUMPRODUCT(--(MOD(COLUMN(CA5:CZ5)-COLUMN(CA5),2)=0),--(CA5:CZ5<>0))