COUNTIF for 2 columns

  • Thread starter Thread starter b1llt
  • Start date Start date
B

b1llt

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
 
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
 
Another 2003 solution is an array formula

=SUM(($K$15:$K$38=K41)*($M$15:$M$38>=1))

Set with CTRL-Shift-Enter
 
I should have mentioned we're still on Excel 2000.
I used these and am getting a #DIV/0! result.
Any suggestions ---thanks,
Bill
 
My bad! Your correct I did have it pulling a #DIV/O! into the data by mistake.
These all work great! Thanks everyone for all your help.
-B1llt
 
Back
Top