Hi,
I would like to do a cumulative sum based on Row and Column criteria :
I would like to do the cumulative month (Year to date)
In the last colomn, I'd like to have the cumul of all the "CY_A_IT_1" for each Items.
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>I tried with SUMIF($B$1:$B$5,$B$1,INDEX($B$3:$F$7,0,MATCH($A3,$A$3:$A$7))) but it doesn't work and I don't understand why. I find just the first result but when I drag the formula the other result are wrong...
How can I do that? I have office 365
Thank you so much for your help
I would like to do a cumulative sum based on Row and Column criteria :
I would like to do the cumulative month (Year to date)
In the last colomn, I'd like to have the cumul of all the "CY_A_IT_1" for each Items.
A B C D E F
<tbody> </tbody> |
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
How can I do that? I have office 365
Thank you so much for your help