Count blank when criteria is met

[Jennyb7714]

I have a report that references an I'd in the first column then another column that specifies the count of a specific item. What I need to do is IF A:A = (reference) then count all non blank cells in column G:G. Can anyone help me out. It seems so simple but I can't get it to work. Oh and col G could be a mixture of formats

Appreciate any and all help

 

[Jennyb7714]

It was that one that worked, but the alternative one didn't - it gave me "0"

 

[jasonb75]

Do your blank cells in column G have formula in them?

 

[Jennyb7714]

not sure if my reply posted - it didn't look like it, so I'm re-posting

in answer to your question - it was that one that worked - but the alternative one didn't.....

 

[Jennyb7714]

no, I even deleted anything that was in there -

 

[jasonb75]

That I'm trying to make sense of, there must be something in your "empty" cells causing these issues, if we can establish what that something is then we should be able to make countifs work.

how about

=COUNTIFS(A:A,$D8,G:G,">< ")