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
Hello, I have try to add the Gross Earnings from my Excel sheet as column in Pivot table, but the totals are false, the sum is not made correctly. I don't understand why. Thanks,
Solved by Z. Y. in 15 mins
Hello, the SUM is not working in the Sort by Valor in Pivot Table. Sort by COUNT() excel works but, if you look at the attachment you will see that sum is a fake. I have checked everything and I really don't understand why is making like this
Solved by X. A. in 13 mins
A simple sum of two cell values is showing up as zero and not the correct number.
Solved by I. J. in 24 mins
I'm trying to figure out a way to sum all data into a master bill of material list.
Solved by S. E. in 17 mins
I'm trying to sum cells associated with a range of dates
Solved by Z. W. in 26 mins
I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")
Solved by M. E. in 30 mins
Each worksheet should include 2017 budget, 2018 budget, and the variance for each of the 4 budget categories; the formula to calculate the variance for each budget category is as follows: variance = (2018 budget – 2017 budget)/2017 budget. In addition, total budgets should be calculated for 2017 and 2018 using the SUM function, respectively, on each worksheet. More specifically,
Solved by T. A. in 23 mins
I have a column of cells with letters and numbers. How do I sum just the number? So example: Column A : Cell 1 - T5
2 - T5
3 - D6
Solved by K. W. in 16 mins
I need to sum the total hours for all the hours in the row.
Solved by D. J. in 29 mins
Sum of hours- I don't know how to sum them all.
Solved by K. F. in 30 mins