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