Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel countif and
is there a "and" condition if you use countif or sumif?
example; 1 c 1 1 c 2 2 < countif(b1:b4,"=c")and(a1:a4,"=1") |
#2
|
|||
|
|||
Hi!
Try this: =SUMPRODUCT(--(A1:A4=1),--(B1:B4="C")) Biff "KEN" wrote in message ... is there a "and" condition if you use countif or sumif? example; 1 c 1 1 c 2 2 < countif(b1:b4,"=c")and(a1:a4,"=1") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |