I want to multiply a range by another range in another sheet only If a month in a date from a range matches the month in another range in another sheet.

Technically:

Multiply $R$8:$R$1007 by Start!$L$13:$L$24 If ARRAYFORMULA(TEXT($N$8:$N$1007,"MMMM")),"="&Start!$K$13:$K$24

Edit: here's a sample of my tables:

CodePudding user response：

Based on the limited information of your sheets. The following would multiply and sum each range if the months are matching:

=SUMPRODUCT(--(TEXT(N8:N1007,"mmmm")=Start!K13:K24),R8:R1007,Start!L13:L24)