 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2007Need formula Help soon
B C E G 2 SubtotalRetail SubtotalCost SubtotalComsn SubtotalGrossProfit 3 =Formula(j7:j10) =Formula(K7:K10) =Formula(l7:l10) =Forml(m7:m10) A B C D I J K L M 6 Date PrdoctID QtyOut QtyNow Descpn Retail Cost CmsnGainLoss 7 26.11.07 200700105 2 8 Stonefgr 1300.00 500.00 01600.00 8 26.11.07 200700106 11 0 Stonefgr 3000.00 600.00 26400.00 9 26.11.07 200700068 2 22 Textiles 600.00 320.00 00560.00 1026.11.07 200700249 1 0 Paintings 21000.00 7000.00 14000.00 Sir, just same format of my worksheet. I need a formula in B3, C3, E3 and ... I want to see what is the exact Gprofit on particular date after data>Filter of Date Column I hope I now cleared to you all thing and you will better understand. Regards RRS I think the "Formula" you want in B3 is: =SUBTOTAL(9,J7:J10) adjust the range to suit, then copy into C3:E3. Hope this helps. Pete On May 15, 5:44 am, Rao Ratan Singh <RaoRatanSi...@discussions.microsoft.com> wrote: > B C E G > [quoted text clipped - 22 lines] > > RRS Thank you pete but when qty out is more than 1 Cost Price will be multiplied by qty out and Sale Price will be multiplied by qty out. so how i should use the formula in b2, c3 etc. Regards. > I think the "Formula" you want in B3 is: > [quoted text clipped - 34 lines] > > > > RRS I think it would be better to introduce new columns N and O - cost * qty out and sale price * qty out, then make the subtotal formulae point to these ranges instead of J, K etc. Hope this helps. Pete On May 15, 12:19 pm, Rao Ratan Singh <RaoRatanSi...@discussions.microsoft.com> wrote: > Thank you pete but when qty out is more than 1 Cost Price will be multiplied > by qty out and Sale Price will be multiplied by qty out. so how i should use [quoted text clipped - 42 lines] > > - Show quoted text - Thank you pete once again. But except then inserting new column how we can directly calculate the range? I hope you will tell me about some innovative. Regards RRS |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.