Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif ????
Hi, I need help (yes psychiatric would be nice at this stage!) to solve my
dilemma. It goes like this.. I have two columns, Column F (F7:F35) called Lead and Column G (G7:G35) called tag. Both columns will contain numbers or a 0 (zero). I need to count the number of cells in in column G that are greater than 0 (zero) BUT also have a zero in the corresponding cell in column F. I have tried "Countif" but I can't seem to get it to work because I because I need to reference the cell next to it. -- All help much appreciated. Thanks from sunny Sydney. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |