MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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"),"")