Need formula Help soon

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

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

Regards


RRS

 

[Pete_UK]

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

 

[Rao Ratan Singh]

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]

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

 

[Rao Ratan Singh]

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