Index+Match+Sum

[Kian0801]

Hi There,

New mate here in this forum, can you please help with my problem, Please see attached file.
Screen Shot 2019-10-17 at 12.53.57 PM.png

The problem is, if I want to change the date to january target should be on january with specific seller, if change to Febuary target should be Jan+Feb and so on, I hope you understand my english. Appreciate your help pls.

[FDibbins]

See if you can adapt my suggestion here to suite your needs...
https://www.excelforum.com/excel-for...t-formula.html

[Kian0801]

Thank you however I'm a little bit confuse on how to apply that on my problem. Appreciate your help

[kvsrinivasamurthy]

Try this.
In G10

=INDEX($B$3:$D$5,MATCH($F10,$A$3:$A$5,0),MATCH($F$8,$B$2:$D$2,0))

[Kian0801]

Hi there tried the formula, it will change the target month on month, however i want to happen is
-- When changing the date to Febuary, the new target is ( Jan + Feb )., if to change to March the new target is ( Jan + Feb + Mar ) and so on.. is this possible?

[kvsrinivasamurthy]

Pl upload a sample file.


To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
be sure to desensitize the data
click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”

The file name will appear at the bottom of your reply.

[menem]

Please try.

Please Login or Register  to view this content.

Regards.

[PaulM100]

Untested, but something like this maybe: =SUMPRODUCT(($A$2:$A$5=$F$10)*(MONTH($B$2:$D$2)>=1)*(MONTH($B$2:$D$2)<=MONTH($F$8)),$B$3:$D$5)