On Dec 17, 11:31*am, Brad wrote:
Try this
=B2+COUNTIF(D2:F2,"=1")

--
Wag more, bark less



"Anthony" wrote:
I have numbers in cells b2, d2,e2, and f2. *I am trying to write
statment that will increment number in cell b2 by one for each cell
(d2, e2, f2) that is greater than or equal to one. *The following
formula will not work if more than one cell (d2, e2, f2) has a zero in
it:

=IF(AND(D2=1,E2=1,F2=1),B2+3,IF(OR(D2=0,E2=0,F2 =0),B2+2,IF(AND
(D2=0,E2=0),B2+1,IF(AND(D2=0,F2=0),B2+1,IF(AND(E2= 0,F2=0),B2+1,)))))

Does anyone know why?

.- Hide quoted text -

- Show quoted text -

I figured it our. Sorry and thanks for your help.