Need formula Help.

[Rao Ratan Singh]

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

 

[JMay]

In B3 enter:

=Subtotal(9,B5:B1000) << This sums only visible cells

and copy over to C3, E3 and G3.

HTH

 

[Rao Ratan Singh]

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]

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]

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 data>Filter
of Date Column

I hope I now cleared to you all thing and you will better understand.

Regards


RRS

 

[Rao Ratan Singh]

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 data>Filter
of Date Column

I hope I now cleared to you all thing and you will better understand.

Regards


RRS

 

[Rao Ratan Singh]

Hop you will be ok and solve my problem soon.