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
[TABLE="width: 447"]
<tbody>[TR]
[TD]PURP
CODE[/TD]
[TD] COMMERCIAL TOTALS[/TD]
[TD]COMMERCIAL COUNT[/TD]
[TD] RETAIL TOTALS[/TD]
[TD]RETAIL COUNT[/TD]
[/TR]
[TR]
[TD="align: right"]114[/TD]
[TD] $ -[/TD]
[TD][/TD]
[TD] $ -[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]
F G H I J
[TABLE="width: 447"]
<tbody>[TR]
[TD]PURP
CODE[/TD]
[TD] COMMERCIAL TOTALS[/TD]
[TD]COMMERCIAL COUNT[/TD]
[TD] RETAIL TOTALS[/TD]
[TD]RETAIL COUNT[/TD]
[/TR]
[TR]
[TD="align: right"]114[/TD]
[TD] $ -[/TD]
[TD][/TD]
[TD] $ -[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]