Sum Column rows for columns containing specific text

[leonielroux]

Good day,

I have a sheet with rows of unique components in column A. Then I have different running month set out from column B to I. I want to sum all the "Claim - Overtime @1.5" of columns that contain the text "December - 2023". HOW do I do that ?

 

[SunnyAlv]

Like This ?

=SUMPRODUCT((A2:A6=A5)*(NOT(1-(IFERROR(SEARCH("*"&"December - 2023"&"*",B1:H1),0))))*B2:H6)