Help with a count example

[Stani]

Hello
Im looking for som help with a formula. I have no clue what Im doing.

So the formula is going to count from a data sheet; how many sales done by a seller spessified with a list of itemnumber. I know it can be done easy with a piviot table but it doesnt work correct with the rest of the sheet.
Tried to sett up a example here so you may understand. Tanks in advance.

Untitled — imgbb.com

 

[Stani]

Can't find a edit button her so to make it more clear i would like a formula: " if store is "1" and seller is "2" Count item 1, item 2 and item3, output amount of items sold.

 

[KasperKL]

Hi Stani,

Although your screenshot is a bit confusing, you need to go with SUMIFS (if you have Excel 2016)

=SUMIFS(G:G, A3:A13, 1, D:D, B3)

Regardless, read some more about the SUMIF/SUMIFS functions here: How to Use the Excel Functions SUMIF and SUMIFS (tutorial)

 

[Stani]

image — imgbb.com

Is this a better example?

 

[MARZIOTULLIO]

can you download a file not a image

 

[MARZIOTULLIO]

e92=SUMIFS(G100:G119,A100:A119,C92,D100:D119,D92)