COUNTIF only if cell has data

[tara_922]

Hiya all!

I need to count data in a range, only if cell H59 has data. When I use the formulas I know it counts it regardless of it being blank.

There is a formula in the blank cell so that may be why excel is counting it regardless of if it is blank.

=IF(G59="","",IF(ISNUMBER(FIND("-",G59)),LEFT(G59,FIND("-",G59)-1),G59))

P.S. I did copy then paste special and values only so I could get rid of the formula. It's still coming up with results when it should be blank!

can somebody please give me a formula for this?? Pretty please...

Thanks,
Tara

 

[villy]

change G59 to H59

 

[tara_922]

Hiya Sorry,

Caught that, just pasted the wrong formula, still not working properly!

Tara

 

[Aladin Akyurek]

Hiya all!

I need to count data in a range, only if cell H59 has data. When I use the formulas I know it counts it regardless of it being blank.

There is a formula in the blank cell so that may be why excel is counting it regardless of if it is blank.

=IF(G59="","",IF(ISNUMBER(FIND("-",G59)),LEFT(G59,FIND("-",G59)-1),G59))

P.S. I did copy then paste special and values only so I could get rid of the formula. It's still coming up with results when it should be blank!

can somebody please give me a formula for this?? Pretty please...

Thanks,
Tara

Try...

=COUNTIF(H59,"?*")

 

[tara_922]

Hiya all!

I ended up simplifying and using
=IF(COUNTIFS(G54,""),"",COUNTIF(G:G,G54))

Thanks for your input, very much valued!

Tara

 

[AlphaFrog]

Another method...

=IF(LEN(G54),COUNTIF(G:G,G54),"")

 

[Aladin Akyurek]

Hiya all!

I ended up simplifying and using
=IF(COUNTIFS(G54,""),"",COUNTIF(G:G,G54))

Thanks for your input, very much valued!

Tara

Better:

=IF(G54="","",COUNTIF(G:G,G54))

 

[tara_922]

You guys are awesome! Thanks so much!

Tara

 

[Aladin Akyurek]

You guys are awesome! Thanks so much!

Tara

You are welcome. Thanks for providing us feedback.