Multiple Cell criteria Sum (Excel 97)

Topic

New Reply

Hi all,

Hope someone can help me out with this one. If I had multiple cells say A1 = 90, B1 = 8, C1 = 3. D1 is were I want the figures summed. The criteria I would like is that if A1 >= 90 then use 100 for the number to be summed, if =10 use 20, if =3 use 5, if <3 use the number in C1. So the number in D1 should be 100+8+5=113.

Thanks.

Reply | Quote

Replies

Put this formula in D1

=SUM(IF(A1>=90,100,A1),IF(B1>=10,20,B1),IF(C1>=3,5,C1))

Hope this is ok, I’m home sick today

Reply | Quote

Thanks so much. This was exactly what I needed.

Reply | Quote