Sum ups

[ahhhmed]

Hello,

Can you help me with this?

I have columns A, B, c, D, E, F

there are numbers in A, B, C, D

When the sum of A:D is between 0 and 20 I want it to appear in column E

When the sum of A:D is larger than 20, I want it to appear in F

Any ideas please?

 

[Luke M]

In E2:

=IF(SUM(A2:D2)<=20,SUM(A2:D2),"")

In F2:

=IF(SUM(A2:D2)>20,SUM(A2:D2),"")

 

[ahhhmed]

Thanks very much Luke.