Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|