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

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