I am having some difficulty creating a formular to copy a cell value t
another only if a certain condition is met.
I am working on a wine cellar program and want to look at wines b
type, variety and calculate values.
I have produced a worksheet that links to another sheet used as a mai
database. I have used auto filter in this new worksheet to seperate th
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 th
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 i
white copy the cell X to cell Z.
Any help would be appreciated.
Thank

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

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.

Hi JE Mc Gimpsey,
Thank you for responding to my question.
How would this satisfy the conditional question (red or white)
Is there a way I can send you the worksheet so you may have a bette
understanding of the problem

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

If you're autofiltering, then filter on red or white.

In article ,
marvontherim wrote:

How would this satisfy the conditional question (red or white)

JE McGimpsey
I'm sorry I guess I'm not explaining myself correctly. I know you ar
trying to help and I hope I'm not wasting your time.

The function:
=IF(D7="RED",G7,0)
Tells me that if D7 is red copy the value of G7 in this cell
My problem is if it dosn't meet that condition I want it to post a $
value
It's probably something small I am overlooking I just can't seem to ge
it right

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

Hi JE McGimpsey
I figured it out and it seems to be working the way I want it to.
Thanks again for your help

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

As far as I can tell, the formula gives exactly the response you're
after: If D7 contains the text "RED", then the value in G7 is entered
into the cell. if D7 does not contain "RED", then 0 is entered into the
cell.

In article ,
marvontherim wrote:

JE McGimpsey
I'm sorry I guess I'm not explaining myself correctly. I know you are
trying to help and I hope I'm not wasting your time.

The function:
=IF(D7="RED",G7,0)
Tells me that if D7 is red copy the value of G7 in this cell
My problem is if it dosn't meet that condition I want it to post a $0
value
It's probably something small I am overlooking I just can't seem to get
it right.

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/

Hi JE Mc Gimpsey,
I think were closer
Column D is where the wine type is recorded.
Column G is where the value is recorded
Column I is where I want only Red wine values to copy
Column J is where I want white wines to copy
And so with other varieties
The wines column may change to different varieties as wine is relocate
around the cellar
The function needs to say If column d D is red than copy the value o
column g in column I if not return a zero
=IF(D7="RED",1,G7),(D7="WHITE",1,H7) and so on for all the variou
varieties.
This function will be in every column that requires a value column
and J etc.

I get dizzy thinking about it

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