Put the subtotal formula in the top row and see if that works

--
Regards,

Peo Sjoblom

(No private emails please)


"Dane" wrote in message
...
I have used this function before and had no problem.
I do not understand why it is not working for me now.
I have approx. 1600 rows of data and I have three columns with the
subtotal
function entered in the row under the last row of data.

When I filter on a specific the data value in one column that I want to
get
a subtotal for, the row wihere the subtotal function is entered does not
display.

Can someone help with this problem please.