Formula to add to get YTD

[rizmomin]

Hello:

Please refer to attached file.
I will be selecting Month and item to be added from cell A3 and A4.

I need formula in cell D2 and D3 to give me the result as shown.
(D2=D9+D14+D19+D24)

Let me know if you have any questions.
Thanks.

Riz

[azumi]

For D2 :

=IFERROR(INDEX(D8:D66,MATCH(C2,C8:C66,0)+MATCH("NET SALE",C8:C66,0)-1),"")

[Bo_Ry]

Please try D3 and press Ctrl+Shift+Enter

=SUM(D9:D61*IFERROR(--(--(C8:C60&C7)< =--(C2&C7)),))

or normal Enter

=SUMPRODUCT(D9:D61,(C9:C61=C9)*(ROW(C9:C61)< MATCH(C2,O5:O16,)*4+ROW(C9)))

[rizmomin]

Hello azumi and Bo_Ry:

Thanks a lot.

Riz