two ways, both assuming wine type is in column C

in column Y:
=if(c2="red",x2,0)
in column Z:
=if(c2="white",x2,0)

or using sumif - in the cell you want the total put:
=sumif(c:c,"red",x:x)
and (in another cell)
= sumif(c:c,"white",x:x)

"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.
Thanks


---
Message posted from http://www.ExcelForum.com/