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 am trying to sum one particular cell (D3) from multiple sheets in excel. My sheet names are 1 through 3. The formula I am using is =SUM('1:3'!D3) but the total I am getting is adding to 0.00 which is incorrect. What am I doing wrong?
Solved by Z. J. in 19 mins
I am needing a pivot table report on the SUM of the number of employees last reported for the year 2017 and for the year 2018 (based on Effective Date column).
Solved by C. A. in 24 mins
I am looking for a formula that will show that if I have a value in a certain cell, it will then take a certain value and multiply it by a sum. I thought an IF formula would work but i cant think of what to write for it. Are you able to help with that
Solved by Z. A. in 11 mins
Hi,
I am having trouble finding the average of a sum.
Solved by I. H. in 19 mins
How do you replace the sum of formula with its resulting digits.
ie
replace
=SUM(J21:AC21)
with 76
Solved by B. B. in 26 mins
how do i get a debit subtracted from a sum
Solved by C. E. in 25 mins
help on IF/OR FORMULA, so if a set of parameters is met then the cell will sum to specific cells.
If the parameters are not set then the formula will sum to other specific cells
Solved by B. J. in 23 mins
Hello there, I am trying to use sum and many if functions like this: sum(if(A1<B1,1,0),if(A2<B2,1,0),if(A3<B3,1,0),.....) and was asking if you know and easier / shorter way to do this.
Thanks
Solved by T. E. in 14 mins
I need to create a formula that adds the sum of all boys and girls who attended each year of camp
Solved by C. U. in 21 mins
I need the sum of column L in Sheet 2 if column A of sheet 2 matches A1 (lets say) in Sheet 1, and "January" appears in column C of sheet 2
Solved by T. E. in 20 mins