Using text from a cell in other formula.

Hi,

I'm looking to try and speed up setting up my spreadsheets each month and would like to have a cell with the month in, which is used in all the other formula. So for example... the formula below I'd like the "*feb*" part to be whatever month I have wrote in cell J1. I'm dealing with data exported from a EQMS to do with tracking activities each month that need completing.

=COUNTIFS(A:A,"feb",C:C,"*feb*",H:H,"y")+COUNTIFS(A:A,"feb",C:C,"*feb*",H:H,"oos")

Thanks,
Becky

Or try this:

=SUMPRODUCT(COUNTIFS(A:A,J1,C:C,"*"&J1&"*",H:H,{"y","oos"}))

Brilliant, thanks the first one worked perfectly.

I'm so confused though as I was certain I had already tried that! Perhaps I still had the " in...

Thanks for your help!