Another slightly shorter formula is

=SUMPRODUCT(($A$26:$A$34=K$1)*(OR((LEFT($B$26:$B$3 4)={"4""5"})))*$D$26:$G$34)

where I guess you must change \ to , (comma). \ is because I use Danish settings.

Edit: {"4""5"} here I wrote {"4" backslash "5"} but it was changed when I posted. I think you should use {4,5}.

Thanks xor,

It works perfectly.

Regards,

Dear xor,

Sorry to bother you again. I am wondering why trail formula is not working on table. Result give count for the total entries in Feb 24 month instead of sum of 4 & 5 series for that month. Is there any reason or am I making any error? Demo file is attached for the reference.

Thanks for your cooperation.

Attached Files

Sum based on criteria Demo 250324.xlsx (269.4 KB, 5 views)