Instances instead of amounts.

[dscheeringa]

I am using the following formula to give me a total dollar amount for gas cards issued: =SUMPRODUCT(--(Consumers!$I$2:$I$997),--(Consumers!$D$2:$D$997=$B17),--(Consumers!$J$2:$J$997>0))
Column I is filled with the value of the gas card issued (either 0, 10, or 20).
Column D is the county issued to. B17-B24 refers to the rows for each particular county.
Column J is my search string helper for the dates I enter to search. EOMONTH kinda stuff.

What I would like to do is use a variation of this formula to count the instances (instead of total dollar amounts) of any value greater than 0.

This is different from my last thread from earlier today.

[Pete_UK]

Just a slight amendment:

=SUMPRODUCT(--(Consumers!$I$2:$I$997>0),--(Consumers!$D$2:$D$997=$B17),--(Consumers!$J$2:$J$997>0))

Hope this helps.

Pete

[dscheeringa]

That was it!

Thanks!

Dan