I need to be able to pick a store and corresponding months and sum the total. For example, StoreB from Feb to Apr (inclusive), the sum would be 9. Searched but couldn't quite find another thread with the answer I need. Thanks!
A | B | C | D | E | F | G | |
1 | Jan | Feb | Mar | Apr | May | Jun | |
2 | StoreA | 50 | 60 | 70 | 80 | 90 | 100 |
3 | StoreB | 1 | 2 | 3 | 4 | 5 | 6 |
4 | StoreC | 9 | 10 | 11 | 12 | 13 | 14 |
5 | StoreD | 15 | 16 | 17 | 18 | 19 | 20 |