Hi all,

I use this formule to pull data from a sheet (Gel Calc);

=SUMPRODUCT(--(TEXT('Gel Calc'!B3:B14;"mmmm")=Dashboard!B22)*('Gel Calc'!D3:D14))
This formule read cell B22 in the sheet Dashboard and gets data from Gel Calc D3:D14.
Now this formule sees januari in B22.

The problem is that only looks for month and not year. It displays data from 2018 now.

I would like to change the formula that it looks for month and year in this format; mmmjj -> jan19 in this case.
jan19 is in E41 with the formulie =TODAY() and cell settings set to custom mmmjj

Anyone knows how i do that?