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 can't get sum of hours-need to know how to sum.
Solved by T. S. in 29 mins
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _ "PivotTable1").PivotFields("S6USEQTY"), "Sum of S6USEQTY", xlSum I keep getting this error when trying to create a pivot table macro. Please Help.
Solved by T. D. in 13 mins
In my cell H26 I have a formula to calculate a value. I want to have this value shown if it is a negative, but if it is a positive number I want it to show 0. The formula I used was: =IF(SUM(H21:H25)>0,0), which works for this cell, but when I copy it to the next cell which calculates a negative number I get FALSE
Solved by E. F. in 20 mins
I would like to sum the column 'Total' if I refer to a value in column 'Prog code'. For example, say, I am looking for prog code 70 then I would like to have the corresponding values in column 'Total' summed. So the answer would be 1300.
Solved by X. W. in 29 mins
I want to make a spreadsheet in which I want to identify 5 people names , their projects, their money allocation and Sum of these monies
Solved by F. J. in 25 mins
If something is going to happen tomorrow, highlight the row/cell yellow. If something is going to happen within three days, highlight the cell green. How do I sum the total payments for a given day? How do I create a macro to re-configure the list to start at today's date How do I create a formula that results in a 0 instead of #N/A?
Solved by G. S. in 11 mins
I'd like to create a formula that says something like sum(d1*1 if D2=5 or 2 if d2=10)
Solved by O. Y. in 26 mins
I'm trying to use a VLOOKUP formula between sheets and add it to a SUM formula to show in separate columns. I'm needing some help with vlookup basics, any pointers?
Solved by S. H. in 22 mins
I have an issue with a formula. I have cells 65:68 in columns D and E, the sum of D needs to subtract the sum of E. Sometimes column D is blank. My formula isn't working =If((OR(D65:D68="")),sum(e65:e68),if(sum(d65:d68>0),sum(d65:d68)-sum(e65:e68))) cell R17
Solved by F. Q. in 22 mins
Hi - I need to maximize installs while staying within a $3,500,000 budget. In other words, I need to find the highest sum of a combination of cells in column F while the sum of the cells in the same row in column G is less than $3,500,000
Solved by D. E. in 16 mins