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!”
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