SUMIF criteria with multiple sum formula

[MarcBK]

Hello all,

I am currently using this formula

=SUM(C6:C1003)+SUM(E6:E1003)+SUM(E1)-E3

to sum total of product a, but we have recently updated product a to be product a 2022 and now need to replicate this to separate between product a and product a 2022

I was thinking sumifs style formula but I cannot do multiple sum criteria on this. can someone help please?

 

[jasonb75]

So how do we differentiate between "product a" and "product a 2000"? Are we going by dates, or is 2022 in the description?

Where do we find that information in your sheet and how does it relate to the values currently summed in your formula?

 

[MarcBK]

So how do we differentiate between "product a" and "product a 2000"? Are we going by dates, or is 2022 in the description?

Where do we find that information in your sheet and how does it relate to the values currently summed in your formula?

Description in column B

Stock in Product A	987	Stock in Product A 2022	961
Stock out Product A	25 =SUMIF(B:B,"Product A",D:D)	Stock Out Product A 2022	50 =SUMIF(B:B,"Product A 2022",D:D)

Column A	Column B	Column C	Column D	Column E
Date	Product Name	Stock in from supply	Stock out	Stock in from secondary
10/10/22	Product A	1000	25
11/11/22	Product A 2022	1000	50
15/11/22	Product A			12
22/11/22	Product a 2022			11

So I calculate Stock out using

=SUMIF(B:B,"Product A",D:D)

and Stock in using

=SUM(C6:C1003)+SUM(E6:E1003)+SUM(E1)-E3

But for stock in I will now need to split this now into two "in columns for product A and product A 2022

 

[jasonb75]

As far as I can see, you just need to use sumif for those in the same way that yo have for the out quantities.

=SUMIF(B6:B1003,"Product A",C6:C1003)+SUMIF(B6:B1003,"Product A 2022",E6:E1003)+E1-E3