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

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