VKL Narayanan wrote:
I have a column in which I have given for sub total the sum formula that
=sum(F6..F8), like this there are several of them in that column.

However at the bottom of the column I want the total of the column excluding
the cells that have the formula =sum

How can I do that?


If possible, use the SUBTOTAL function instead of SUM for your sub totals in the
column and for the column total at the bottom.