Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif
I have a client that needs to do a countif. The problem is is that the range is not consecutive cells. For example the range may be C3, E3, G3 but not including D3 or F3. How can this be done? -- maryj |
#2
|
|||
|
|||
Hi!
Based on you example (but I have a feeling that you will change it after I've posted this! <g) =SUMPRODUCT(--(MOD(COLUMN(C3:G3),2)=1),--(C3:G3="a")) Replace "a" with your criteria. Use the quotes if it's a TEXT value. Do not use the quotes if it's a numeric value. Biff -----Original Message----- I have a client that needs to do a countif. The problem is is that the range is not consecutive cells. For example the range may be C3, E3, G3 but not including D3 or F3. How can this be done? -- maryj . |
Reply |
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 |