Sumproduct by month/year with an if function?

[elias88b]

Hello guys,

I have managed to implement a sumproduct formula by month&year but I want to add maybe an If function that it will ignore the blank cells of another column.
Please find enclosed the excel worksheet.

Thank you very much in advance for your contributions.

[AliGW]

Try this:

=SUMPRODUCT((MONTH(A2:A443)=2)*(YEAR(A2:A443)=2022)*(C2:C443<>"")*(B2:B443))

[elias88b]

Hello Ali,

Thanks for the prompt response. Works great.
What do I need to insert in case I want it to ignore the cells with value instead of blanks?

Thanks, E.

[AliGW]

I think you mean this:

=SUMPRODUCT((MONTH(A2:A443)=2)*(YEAR(A2:A443)=2022)*(C2:C443="")*(B2:B443))

[elias88b]

Works like a charm. Thank you very much!

[AliGW]

Glad to have helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks for the rep.