Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF for 2 columns
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF across sheets in columns | Excel Worksheet Functions | |||
COUNTIF - across 2 columns | Excel Worksheet Functions | |||
Countif for 2 columns | Excel Worksheet Functions | |||
countif in 2 columns | Excel Discussion (Misc queries) | |||
Help with countif using two columns | Excel Worksheet Functions |