How to sum multiple rows and columns

Please see data example below.

In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for February 2017, I want it to be rolled forward (add ABC’s session 1 for both Jan and Feb)

Any help will be greatly appreciated! Thank you! 

Data Sheet

    Jan-17 Feb-17 Mar-17
ABC Session 1               –        (50.00)               –  
ABC Session 2      (15.00)        15.00        12.00
ABC Session 3        30.00      200.00        12.00
BCD Session 1      400.00               –      (300.00)
BCD Session 2      (50.00)      100.00      150.00
BCD Session 3               –        (50.00)               –  
CDE Session 1        16.00      300.00               –  
CDE Session 2        50.00      100.00        15.00
CDE Session 3        90.00      (10.00)          5.00

 

Input Sheet

   Jan-17 Feb-17 Mar-17
S1 S2 S3 S1 S2 S3 S1 S2 S3
ABC                  
BCD                  

CDE

                 

By: Esther

280 thoughts on “How to sum multiple rows and columns

Comments are closed.