SOLVED

Contributor

# Challenge Excel 2

Hello my Friends

I have problem in applying a formula in Excel ,
I have some items with unique Cod, we are selling them , and fore each of them we buying specific Quantity,
I need a formula that Sum all the selling and deduce it from Purchase and give me the remain in Stock for each item with specific cod and repeat it,

I attached the excel file,

Thank you for your guide in advance

6 Replies

# Betreff: Challenge Excel 2

sry i don't understand your intentions ... do you want Purchase to automatically deduct the saling quantity? ... that would simply be a formula in the row of floors: "= G8-F8" ..or is it something else? ... which is more likely.

Nikolino
I know I don't know anything (Socrates)

# Betreff: Challenge Excel 2

sry floors = Stock row

# Re: Challenge Excel 2

Hello @Jalal_1988,

I'm afraid I do not completely understand what you're asking for. Perhaps you could manually fill in the "Stock" column to illustrate what values you wish to achieve.

As a guess, maybe what you're looking for is something like the following in the first row of the "Stock" column (assuming your table starts in cell A1):

=\$D2-SUMIFS(\$C\$2:\$C\$21,\$A\$2:\$A\$21,\$A2,\$B\$2:\$B\$21,\$B2)

# Re: Challenge Excel 2

Hello @PReagan

I manually filled the Stock column for your understanding, Purchase column is repeated for each Cod and item, I need formula that Deduce the Sum of selling from Purchase, and give it in Stock ...

# Re: Challenge Excel 2

Great, understood. Thank you! In that case, is the formula in my previous post similar to what you're looking for?

Best Response confirmed by Jalal_1988 (Contributor)
Solution