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

I am trying to set up a sales sheet where where I have 2 payment options that has different fee's for the payments. But I have having issues trying to get the total of the payment minus sales tax to sum up. Here is what I really need to happen: I currently have this: =IF(L41,SUM(D41-L41),"") which is for only one payment option. But I can't get =IF(L42,SUM(D42-L42), (F42-L42)) to work. It only shows me the negative tax which is in L42. I have tried other formulas but have gotten to the point that I don't know what I have tried or haven't. Any help would be appreciated.
Solved by M. E. in 15 mins
I'm creating a spreadsheet totalling maths scores for my class and the times completed in minutes and seconds. Ive put all values in 3 separate columns. Ive managed to sum the scores and times of 4 tests over the week in separate columns. The data ive got I have to upload onto software where seconds cannot go over 59. Is there a way of formatting the seconds column that if the total of seconds exceeds 59, it resets to 0 and adds 1 to minutes columns of if it exceeds 119 it adds two etc?
Solved by A. L. in 29 mins
I cant come up with a sum formula for my template
Solved by B. H. in 14 mins
I'm trying to sum one column if it matches the criteria of a second column on the same row.
Solved by G. E. in 18 mins
Column D is not adding properly. The Sum formula is giving $12,771.86 as the answer while it should be $12,771.88. Thoughts?
Solved by A. D. in 22 mins
Is there a function or macro that can load different cell blocks dependent on another, outside cell. Ex. If A1 is Yes, C1, D1, and E1 are highlighted red with a black border outline and with sum functions. If A1 is No, C1, D1, and E1 are highlight blue with no outline and with if functions.
Solved by B. L. in 12 mins
I am working on an optimization problem. The Objective is to minimize total shipping costs and we have to decide how many to ship from each plant to each warehouse. Our constraints are that the number to ship cannot be less than zero and the total number shipped to each warehouse must be equal to or greater than demand. I need to use the SUM and SUMPRODUCT functions, and solver to find the optimal solution
Solved by F. C. in 28 mins
I am trying to sum up a column and I want any number that exceeds 4256.89 to just add as 4256.89. Help please!
Solved by K. Q. in 16 mins
Hello I am trying to multiply columns B and C, and then adding that sum with columns E and F and cannot figure out the formula to do that for the worksheet
Solved by T. U. in 23 mins
Needing help with a formula to assign a value of (1) for cells from another spreadsheet that have blank values in them while also continuing to sum the total value of blank cells
Solved by G. E. in 30 mins