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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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,884
Messages
6,175,175
Members
452,615
Latest member
bogeys2birdies

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