Great suggestion Bob, also if your using excel 2007 you can use the COUNTIFS
function:

=COUNTIFS($C$1:$C$299,$B$300,$J$1:$J$299,""&0)

AGV

"Bob Phillips" wrote:

Try

=SUMPRODUCT(--($J$1:$J$2990),--($C$1:$C$299=$B300))

--

HTH

Bob

"b1llt" wrote in message
...
I'm trying to set a parameter of the following in a formula in column J:
=COUNTIF($C:$C,$B300)
That also only counts the number of times in column J where a cells
(J1:J299)
value is greater than "0". ----this is where I can't figure out the how
to??

In other words, I need to set-up a formula in column J row 300 that I want
to count
the number of times that column C is equal to cell B300 only if the value
in
column J's cell is greater than zero.
Thanks, Bill


.