If function problem

[_ratS]

Hi, this might be a n00bie question, but:

how do i select multiple cells for range criteria?... and i dont mean from i3:i8 but what i mean is logical test being checked on cells like that:

"for cells B29;F30;E31 check whether the value is 1 or 0 and then count it"

actually what i want is:
if b29 = 1 , then add 500 to selected field (E28 = +500)
if f30 = 1 , then add another 500 to selected field (E28 = +500 = 1000)
if e31 = 1 , then add another 500 to selected field (E28 = 1500)

BUT if i only could check multiple cells for their value being 1 or 0 i could count the "1"'s and thenjust multiply it with the number i want.

So anyone got any idea how to do it?
Thx

 

[AlphaFrog]

If the cells have only a 1 or 0, then this will count the 1s in cells B29, F30, E31
=SUM(B29,F30,E31)

Or just put this in E28
=SUM(B29,F30,E31)*500

 

[_ratS]

oh thanks thats great yes.

but what if i want another field to subtract if its value is true?

so:
=SUM(B29,F30,E31)*500

and

if E32 = 1 then subtract some number

somthing like
=SUM(B29,F30,E31)*500; IF(E32=1;-80)

HOW TO WRITE THIS?

 

[AlphaFrog]

Something like this...
=SUM(B29,F30,E31)*500+IF(E32=1,-80)