Confused - Count in multiple fields

[JBank19]

I am current at a loss and in need of help. Below is the data I am trying to count from. I currently have the count function of: =COUNTIF(G1,"<> 0") in column H. This works if there is a balance in column G. I wanted to take it a step farther and basically if G is zero then if F is "114" count that. And I should get a count of 1 then in column H. I have spent a lot of time trying to figure this out. I feel like I'm very close, but still far away. Please help, I hope I was clear in describing the situation.

F G H I J

PURP CODE	COMMERCIAL TOTALS	COMMERCIAL COUNT	RETAIL TOTALS	RETAIL COUNT
114	$ -		$ -	0

<tbody>
</tbody>

 

[Joe4]

Excel has a COUNTIFS function, which allows you to use more than one criteria.
See: https://www.techonthenet.com/excel/formulas/countifs.php

 

[JBank19]

Thank you, but unfortunately when I make the formula =COUNTIFS(G1243,"<> 0",F1243,"=114") it returns a 0 instead of a 1. Any thoughts on how to fix this?

 

[Joe4]

Is the value in column F text or a number. Note the numeric value 114 is NOT the same as the text value "114".

If you are just checking one row of data, you don't need to use COUNTIF or COUNTIFS. Those are really for doing a whole range of rows at once.
Just use:

=IF(AND(F1243="114",G1243<>0),1,0)

if F1243 is text or

=IF(AND(F1243=114,G1243<>0),1,0)

if F1243 is numeric