Need 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 dataFilter of Date Column I hope I now cleared to you all thing and you will better understand. Regards RRS |
Need formula Help soon
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 wrote: 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 dataFilter of Date Column I hope I now cleared to you all thing and you will better understand. Regards RRS |
Need formula Help soon
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. "Pete_UK" wrote: 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 wrote: 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 dataFilter of Date Column I hope I now cleared to you all thing and you will better understand. Regards RRS |
Need formula Help soon
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 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 the formula in b2, c3 etc. Regards. "Pete_UK" wrote: 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 wrote: 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 dataFilter of Date Column I hope I now cleared to you all thing and you will better understand. Regards RRS- Hide quoted text - - Show quoted text - |
Need formula Help soon
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 |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com