Home

Ask The Experts

The follow information is obtained from Yahoo! online community and does not express the views, opinions, or technical advice of On-Site. On-Site is not responsible for damages from use of information from Yahoo! Answers

Questioner's avatar
 How do I get Excel to give me a variable sum total?
I have a column. The column is full of numbers that I need to total (if numbers are input). The sum must be variable based on the amount of numbers input. If one number is entered, it's normal value should show, if 2 numbers are entered, the sum x .95 should show, if 3 or more numbers are entered, the sum x .9 should show. What I did was, I did the calculations in a different column to get the percentage values, then I did this to reference: =IF(G8>0,H8,IF(G9>0,H9,IF(G10>0,H10,IF(G11>0,H11,IF(G12>0,H12))))) The problem is it only works for the first number at the top of the column. How do I get "if" to work? Or any better idea to calculate my total?
2 answer(s)
Best answer avatar
 Best Answer:
B1 =IF(COUNT(A:A)=1,SUM(A:A), IF(COUNT(A:A)=2, SUM(A:A)*0.95, SUM(A:A)*0.9))

View more answers to this question.