Forum Discussion
gloriaBRC802
Nov 27, 2020Copper Contributor
Sum Indirect not working
I have a spreadsheet that is divided into several sections and I need each section to be totaled separately. I am using =SUM(INDIRECT("E$22:E"&ROW()-1)) to have to rows automatically include any new ...
gloriaBRC802
Nov 27, 2020Copper Contributor
yes, I did but it doesn't add up all the lines in the separate sections. It works but only for a few of the lines
Riny_van_Eekelen
Nov 27, 2020Platinum Contributor
gloriaBRC802 Really sorry, but don't understand what you mean.
- Riny_van_EekelenNov 27, 2020Platinum Contributor
gloriaBRC802 Glad you resolved it!
- gloriaBRC802Nov 27, 2020Copper Contributor
Riny_van_Eekelen I see what I did wrong. Thank you for your help.