In order to clarify the scenario, please check the example here:

CodePudding user response：

Sumifs is different than Sumif. You also have some text mixed with numbers. Your dates are text while Column b is numeric. Try this:

=Sumifs(C:C:,A:A,"2022-09-08",B:B,82267,B:B,82602)   
 Sumifs(C:C:,A:A,"2022-09-08",B:B,82267,B:B,82602B:B,82604)

As Player() points out, if you have too many products to include, using sumifs would get pretty tedious and you ought to consider using a different function (i'd use filter). However since your question was Sumifs related, that's your answer.

To illustrate how this would work with something Filter, you could do this:

=sum(filter('raw data'!C:C,('raw data'!A:A=A2)*
  (isnumber(match('raw data'!B:B,'ids to match'!A:A,0)))))