Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIF or SumIf Question
Hello,
Following up on previous help provided and which as worked great: Without having to add a column to a spreadsheet, I need to count the number of rows that match criteria based on three columns. That is, If column A is blank AND column B=0 AND column C=0, this would count as 1 valid row, otherwise 0 valid row. It looks like I could do this somehow with IF() and I'd like to use one of the functions you guys have been referencing (sumIF, countIF, etc.). I do not know how to use compound criteria. I thought I could do something like =Sum(IF(A="" AND B=0 AND C=0, 1, 0)), but that doesn't seem to work. I see there is an AND function: AND(A="",B=0,C=0) or something like that. I know I could use a DCount() function, but I was hoping to avoid using criteria columns in my spreadsheet. Very confused. Thanks for any help! John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or SUMIF question | Excel Worksheet Functions | |||
function question (sumif countif conditional) | Excel Worksheet Functions | |||
countif/sumif question | Excel Programming | |||
sumif / countif question | Excel Programming | |||
Countif/Sumif function question | Excel Worksheet Functions |