I need Excel help quickly PLEASE

[robisc]

OK I need excel help quickly, this is driving me crazy

I have 5 columns (A thru E) that will have number values assigned, then there are 3 additional columns (F thru H) so what I want to do is to be able to put numbers in the first 5 columns and when I fill in a value in the last column (E) I want the total of all 5 columns to be filled into the appropriate column either F, G or H depending on the range of the total, the ranges are to be: column F total 10 or below, column G total 11 thru 14, column H total 15 thru 18. This should be easy for an excel guru but not me.

 

[KLin]

look at attached code.

 

[SaintTigurius]

here is your homework done for u

in field F

=IF(SUM(A1:E1)<10, SUM(A1:E1))

i am going to help u out with that, but if u want between u will need to use the AND commanded somehwere in this..
GL

 

[robisc]

You are great thanks, one little problem though, when for testing I use in columns A1 thru E1 the numbers 1 thru 5 respectively I get the total of 15 which is correct but I get it in 2 columns rather than 1, it shows 15 in column G and H, while it should only be in coumn H, looked at your formula and can't figure it out though.