excelperkins
New Member
- Joined
- Jun 4, 2018
- Messages
- 2
Can anyone recommend a formula for the below table:<o
></o>
<tbody>
</tbody><o> </o>
I am trying to total up the value of row 4 and return theresult in column O. <o></o>
However I only want to return the accumulative result up tothe specified month in cell C1.<o></o>
As an example if I put “APR” in C1 it would return the value14 in cell O4, then if I were to switch it to “JUN” it would return the value23.<o></o>
Many thanks in advance.<o></o>
></o>| A<o></o> | B<o></o> | C<o></o> | D<o></o> | E<o></o> | F<o></o> | G<o></o> | H<o></o> | I<o></o> | J<o></o> | K<o></o> | L<o></o> | M<o></o> | N<o></o> | O<o></o> |
| 1<o></o> | Reporting Month<o></o> | xxxx<o></o> | ||||||||||||
| 2<o></o> | ||||||||||||||
| 3<o></o> | Name<o></o> | JAN<o></o> | FEB<o></o> | MAR<o></o> | APR<o></o> | MAY<o></o> | JUN<o></o> | JUL<o></o> | AUG<o></o> | SEP<o></o> | OCT<o></o> | NOV<o></o> | DEC<o></o> | TOTAL<o></o> |
| 4<o></o> | Janet<o></o> | 2<o></o> | 4<o></o> | 5<o></o> | 3<o></o> | 4<o></o> | 5<o></o> | 3<o></o> | 2<o></o> | 5<o></o> | 6<o></o> | 2<o></o> | 3<o></o> |
> </o>I am trying to total up the value of row 4 and return theresult in column O. <o
></o>However I only want to return the accumulative result up tothe specified month in cell C1.<o
></o>As an example if I put “APR” in C1 it would return the value14 in cell O4, then if I were to switch it to “JUN” it would return the value23.<o
></o>Many thanks in advance.<o
></o>
