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

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