pls help with sumifs and three criteria

[shmemushi]

Hi

I want to know sum of products that is sold in each month to any store by any seller

thank you

[Bo_Ry]

Please try at H8

=SUMIFS($D:$D,$B:$B,$G8,$C:$C,H$7,$E:$E,">=1"&H$6,$E:$E,"<"&EDATE(1&H$6,1))

or
=SUMPRODUCT($D$5:$D$20,($B$5:$B$20=$G8)*($C$5:$C$20=H$7)*(TEXT($E$5:$E$20,"mmmm")=H$6))

[protonLeah]

pivot table is also an option.

[shmemushi]

Thank you Bo_Ry! it is perfect for what i need. I can edit as i need it! Thank you again. Solved!

[shmemushi]

pivot table is also an option.

Your formula is a good solution too! But it is so advanced that i cannot edit according to my changes! Thanks a lot