krunal123

Board Regular
Joined
Jun 26, 2020
Messages
177
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
1660634605824.png


@ How to Get Period-wise Stock

N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN)


O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Just add another condition to your formula - That is the beauty of SUMIFS

Excel Formula:
=SUMIFS(E:E,C:C,L3,D:D,M3,B:B,">="$S$2",B:B,"<="&$U$2)

Try it
 
Upvote 0
And far better way is pivot tables if you have start and end date exactly as Month Beginning & Month End. Else SUMIFS would do as told above.
 
Upvote 0
And far better way is pivot tables if you have start and end date exactly as Month Beginning & Month End. Else SUMIFS would do as told above.
i was make SALE & PURCHASE PIVOT TABLE ,

but i was fail for make this stock match with date wise in pivot table
 
Upvote 0
i was make SALE & PURCHASE PIVOT TABLE ,

but i was fail for make this stock match with date wise in pivot table
Two things Krunal
If you want Pivot table to do everything you have to bring both inward and outward transaction in one table but quantities in seperate column - Just like we do for banking transactions.

Else did you try the formula I gave you above - that shall summarize all your values at one place with as many conditions you want to apply.

Try that
 
Upvote 0
Look at this -

All Records.xlsb
ABCDEFGHIJK
1DateCategoryProductInwardOutwardNoteSummary
21-JunFlourCorn Flour20Opening Bal1-Jun30-Jun
31-JunFro vegMethi50Opening BalProductNetInwardOutward
41-JunSnacksNamkeen20Opening BalCorn Flour47054070
51-JunFlourRice Flour30Opening BalMethi(50)200250
61-JunFlourCorn Flour520Namkeen510840330
71-JunFro vegMethi150Rice Flour30300
82-JunSnacksNamkeen820
96-JulFlourRice Flour1,430
101-JunFlourCorn Flour70
114-JunFro vegMethi250
129-JunSnacksNamkeen330
1310-JulFlourRice Flour650
Sheet1
Cell Formulas
RangeFormula
I4:I7I4=SUMIFS(StockAccount[Inward],StockAccount[Product],[@Product],StockAccount[Date],">="&$H$2,StockAccount[Date],"<="&$I$2)-SUMIFS(StockAccount[Outward],StockAccount[Product],[@Product],StockAccount[Date],">="&$H$2,StockAccount[Date],"<="&$I$2)
J4:J7J4=SUMIFS(StockAccount[Inward],StockAccount[Product],[@Product],StockAccount[Date],">="&$H$2,StockAccount[Date],"<="&$I$2)
K4:K7K4=SUMIFS(StockAccount[Outward],StockAccount[Product],[@Product],StockAccount[Date],">="&$H$2,StockAccount[Date],"<="&$I$2)
 

Attachments

  • Screenshot 2022-08-16 at 14.53.48.png
    Screenshot 2022-08-16 at 14.53.48.png
    44.8 KB · Views: 10
Upvote 0
Solution
Krunal if the solution resolves your issue, please mark the thread as closed and the post with probable solution. It help others to reach the solution faster.

Thanks a lot
 
Upvote 0
Krunal if the solution resolves your issue, please mark the thread as closed and the post with probable solution. It help others to reach the solution faster.

Thanks a lot
1660733318215.png


#How to make this pivot table This type Need " Expenses" Summery Report in pivot table.

i was try but not showing this style.......
pleased help for this pivot table summery

(Query Purpose : if then 100 or more Party, Need party wise Different- Different Expenses use.... if then this Situation , How to making report for this type.....
Sir Kindly Understand and help me......again

*Pleased Help and Share Screen Shot ,
and Send Steps for how set data hader
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top