CountIf Help needed

[mofan1]

Hello All! I'm working on a spreadsheet and I'm trying to data in cells that are alpha and numeric. The cells show this info: 1R,2Y; 1R,2Y,4R. There are more cells than that, but here's the formula I'm trying to use: COUNTIF(B$4:DE$17,"=1") - COUNTIF(B$4:DE$17,"*G*"). The answer keeps coming up -70 and all I'm really looking for is the formula to look at the cells and tell me if there is a '1' in the cell and the alpha character next to it is a G, then count that. So I counted this spreadsheet manually and the answer to this should be 5, because there are only 5 1Gs in the spreadsheet. How can I fix this issue?

 

[RoryA]

Welcome to the forum.

=COUNTIF(B$4:DE$17,"*1G*")

should do that for you.

 

[mumps]

Try: =COUNTIF(B$4:DE$17,"*1G*")

OOPS. RoryA beat me to it.

 

[mofan1]

Thanks All, that did the trick!

 

[mumps]

Glad to help.