IF + COUNT IF Questions

D

Danielle

I need a statment to look like:

=IF(B3:B33=N127,COUNTIF(Sheet1!CE4:CE9,3)/L3,0)


But I get #Value!

I am assuming I need a sumproduct?? Can someone help with this formula?

D.
 
B

Bob Phillips

do you mean

=IF(COUNTIF(B3:B33,N127)>0,COUNTIF(Sheet1!CE4:CE9,3)/L3,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top