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

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