Get instant live Excel expert help with SUM Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I'm an excel novice and trying to work out how to get the below Sum into a spreadsheet. please help? £7.00 x 13.8% + = x 14.8% + = x 33% + =x 1% + = Charge Rate
Solved by V. U. in 18 mins
I'm trying to sum up numbers in column 3 but only if column 2 holds a 'Y'
Solved by B. D. in 19 mins
I'm trying to sum hours worked by staff on a Saturday, but no more than 2 hours if 38 hours have been worked during the week (Mon-Fri)
Solved by C. L. in 26 mins
I want to know if there is a function that provides the overall amount of weight loss out of each submission in an a entire column. Just like how at the end of a column you can do the sum or the average, etc. I want it to constantly be able to provide a new number by subtracting every time I put a new number in the column.
Solved by G. L. in 20 mins
IF i consider A,B, C as my excel column, i am trying to find the cumulative sum in my C column (for example A1+B1 = C1 in first row and then in second row i need A1+A2+B2 =C2) simillarly A1+A2+A3+B3 =C3. how can i do that using excel formula?
Solved by E. Q. in 25 mins
I am trying to do a formula where I enter the current period into a given cell and have monthly expenses entered below the month (09/30/16 in cell A1 and $50 in cell A2) and I want a sum for all expenses where the date is greater than the current period date but equal to or less than 90 days. I am trying to total the expenses for 90 days greater than the current date.
Solved by F. H. in 12 mins
I have 2 columns one with product and the other with values $dollars values attached to the product, some of the products occur multiple times in the columns. I want to get excel to add all the values attached to a particular product. How do I do this? I used Sum(Lookup.....) but it just picks the first value, it doesnt sum all values.
Solved by K. L. in 18 mins
Hi..I want to sum a range of data based on dates..
Solved by O. J. in 11 mins
I am trying to sum the total by invoice number
Solved by C. S. in 22 mins
ok I'm trying to sum a set of cells and then subtract another set of cell to return a total so (A1, C1)-(D1, K1)=
Solved by G. J. in 30 mins