coutif - I think!
Posted by karen on February 16, 2001 4:24 AM
I need to make a formula that will count the number of entries in column e if the corresponding entry in column b is equal to 2. I have tried a countif but can't seem to make it work - any ideas anyone please!!
Posted by Aladin Akyurek on February 16, 2001 5:35 AM
Array-enter (control+shift+enter)
C1 =SUM(1*(A1:A4<>0)*(B1:B4=2))
or, tout court,
C1 =COUNTIF(B1:B4,2)
Aladin
Posted by karen on February 16, 2001 5:57 AM
Sorry! I should have said i need to count the number of entries in colum e with a value greater than 30 if the number in column b is 2!
Posted by Mark W. on February 16, 2001 6:26 AM
Use the array formula,
{=SUM((B1:B4=2)*(E1:E4>30))}
Posted by Aladin Akyurek on February 16, 2001 6:33 AM
Change the array-formula to
=SUM(1*(E1:E4>30)*(B1:B4=2))
Remember control+shift+enter to enter this formula.
Aladin
Posted by Don Levesque on February 18, 2001 8:49 AM
Try this: =IF(C1=2,COUNTIF(E1:E9,">29"),"")
