Get instant live expert help on I need help with excel sum row

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I copied data from 1 Excel spreadsheet to another Excel spreadsheet. The receiving spreadsheet won't SUM the numbers in a row or column??????????
Solved by B. E. in 13 mins
FORMULA TO SUM DYNAMIC RANGE OF ROW LIKE THIS , =SUM($3:$3) BUT IT WRONG
Solved by M. H. in 30 mins
=IF ("word" [in row], SUM [cell]+[cell]+[cell]
Solved by X. A. in 12 mins
i want to use the value in two fields to generate a sum statement like the following. AE55 contains the start row and af55 contains the last row. the sum statement should read sum(g53:g55). =IF(AE55>0,SUM("G",INDIRECT(AE55),":G",INDIRECT(AF55),")"," "))
Solved by T. H. in 25 mins
formula for sum of row only with _ve number, ignoring -ve #
Solved by O. C. in 17 mins