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.![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
F G H I J
<tbody>
</tbody>
F G H I J
PURP CODE | COMMERCIAL TOTALS | COMMERCIAL COUNT | RETAIL TOTALS | RETAIL COUNT |
114 | $ - | $ - | 0 |
<tbody>
</tbody>