If you're using autofilter, I'd suggest you look at SUBTOTAL().

Assume your cost is in column C. Use

=SUBTOTAL(9, C:C)

which will sum the visible cells in column C.

In article ,
marvontherim wrote:

I am having some difficulty creating a formular to copy a cell value to
another only if a certain condition is met.
I am working on a wine cellar program and want to look at wines by
type, variety and calculate values.
I have produced a worksheet that links to another sheet used as a main
database. I have used auto filter in this new worksheet to seperate the
types of wines I want to look at (red, white etc)
Now that I'm able to seperate the wines by type I want to know the
total value ot that type. I need a formular that saids
' If the type is red copy the value in cell X to cell Y. If the type is
white copy the cell X to cell Z.
Any help would be appreciated.