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

sum of cells between two values in different sheets of excel

Solved by D. H. in 15 mins

When I do auto sum in excel the sum is adding an extra cell for example if the cells are 25 each and I have four of them the sum should be 100 but my sum is 125.

Solved by M. C. in 13 mins

I need a formula that will tell me the sum of cells that have a greater value than 0. Not the sum of the numbers in the cells but if its used =1 not used= 0 kind of sum.

Solved by M. U. in 20 mins

On this particular Excel sheet when adding cells together (like B1+B2) the answer is not the sum of the cells but =B1+B2

Solved by V. E. in 29 mins

I need a formula to sum a range of cells in Column "E" based on text in Column "B" "Total" . The range of cells to copy is in Column "D"
B22= "Total"
D22= SUM(D18:D21) to copy
E22=SUM(E18:E21) to add
It is important to note that the range of cells in column "D" and "E" vary in each grouping.

Solved by A. J. in 13 mins