Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
Sir/Madam,
I have a workbook which have Two sheets. First sheet for Inventory (purchases) and second sheet is Transaction (Sale out). In the Transaction sheet at Top I want to sum after Filter of Retail Price, Cost Price Commission and Gross Profit. Means I want to subtotal of above column in B3, C3, E3 and G3 Cell. I hope someone from you will definetly help me. Regards RRS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
In B3 enter:
=Subtotal(9,B5:B1000) << This sums only visible cells and copy over to C3, E3 and G3. HTH "Rao Ratan Singh" wrote: Sir/Madam, I have a workbook which have Two sheets. First sheet for Inventory (purchases) and second sheet is Transaction (Sale out). In the Transaction sheet at Top I want to sum after Filter of Retail Price, Cost Price Commission and Gross Profit. Means I want to subtotal of above column in B3, C3, E3 and G3 Cell. I hope someone from you will definetly help me. Regards RRS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
Dear JMay,
you know this formula works only in the Normal position. But when I filter according to Date e.g. on 07 May, 07 how much sale and what is the total cost of item and what is the total Gross Profit. Then what type of formula i should use. Regards RRS "JMay" wrote: In B3 enter: =Subtotal(9,B5:B1000) << This sums only visible cells and copy over to C3, E3 and G3. HTH "Rao Ratan Singh" wrote: Sir/Madam, I have a workbook which have Two sheets. First sheet for Inventory (purchases) and second sheet is Transaction (Sale out). In the Transaction sheet at Top I want to sum after Filter of Retail Price, Cost Price Commission and Gross Profit. Means I want to subtotal of above column in B3, C3, E3 and G3 Cell. I hope someone from you will definetly help me. Regards RRS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
I assume your Date column is other than columns B, C E and G.
If your date column is say column A, you would filter on by selecting a May 7 row, and the formulas provided should total ONLY the rows with the visible May 07 rows. After that I'm not understanding your problem. "Rao Ratan Singh" wrote: Dear JMay, you know this formula works only in the Normal position. But when I filter according to Date e.g. on 07 May, 07 how much sale and what is the total cost of item and what is the total Gross Profit. Then what type of formula i should use. Regards RRS "JMay" wrote: In B3 enter: =Subtotal(9,B5:B1000) << This sums only visible cells and copy over to C3, E3 and G3. HTH "Rao Ratan Singh" wrote: Sir/Madam, I have a workbook which have Two sheets. First sheet for Inventory (purchases) and second sheet is Transaction (Sale out). In the Transaction sheet at Top I want to sum after Filter of Retail Price, Cost Price Commission and Gross Profit. Means I want to subtotal of above column in B3, C3, E3 and G3 Cell. I hope someone from you will definetly help me. Regards RRS |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
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 Cmsn GainLoss 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
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 Cmsn GainLoss 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula Help.
Hop you will be ok and solve my problem soon.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|