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

If A26:A50 match A3 add values to B3 for total sum
Solved by D. C. in 22 mins
I'm having trouble w/ a sumifs formula. I have 3 columns that I want the sum for 2 selections and if I do any more than 1 column the formula doesn't work.
Solved by T. U. in 28 mins
Assigning numerical values to non-numerical text and finding the sum of multiple non-numerical texts that have been assigned values
Solved by M. Q. in 24 mins
I have a complicated SUMIF problem I think: I want to sum the values in a column only if in 2 other columns, numbers match each other. I.e. if value in A2 matches A3 AND value in D2 matches D3, I want the sum of numbers in C1:C4 added. I've uploaded version of spreadsheet with all columns but with most of the records deleted (it's a large file with >100k records). In my spreadsheet, I want column FK to add up the numbers in column ES only when the values in column A match each other and the values in columns DN match each other.
Solved by E. H. in 19 mins
excel file, 9 worksheets each sorted by duplicate items in column D. I need to sum up the values of the individual items (column F) with the objective of finding my top moving products sold.
Solved by X. D. in 13 mins
How do I keep a cell's value zero even though the sum should be below zero? example: 825 - 1000 = -175 x 0.090 = -15.75 + 90 = 74.25. I want the answer to be: 825 - 1000= 0 x 0.090 = 0 + 90 = 90
Solved by M. F. in 20 mins
Hi when I have totals of formulas being added the sum takes into account all the decimals that are hidden, causing the sum of the visible numbers to be incorrect How do I set my sum to only add the numbers as they are rounded or visible and to NOT add the hidden decimals?
Solved by B. B. in 16 mins
I need to get the sum of the same client id's order amounts
Solved by E. W. in 19 mins
I need to know how to treat cells differently (i.e., to determine whether to add them up as part of a sum) based on the color of the cells.
Solved by T. L. in 11 mins
when i am creating a Sumif it is working perfectly however the sum is not picking up this one row of data that is the same as all the rows in the spreadsheet. Is there a reason for why it isnt picking up this data.
Solved by A. J. in 19 mins