Need formula Help.

  • Thread starter Rao Ratan Singh
  • Start date
R

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
 
J

JMay

In B3 enter:

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

and copy over to C3, E3 and G3.

HTH
 
R

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
 
J

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.
 
R

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top