Sumif?
 

Hi,

wondered if someone can give me a bit of help.

I have 4 columns, A, B, C, and D.

In column A I numeric value (£1500.00 for example)

In column B I want to either put Yes or No

If I have put Yes in column B, I want column A's figure to appear in
column C.

If I have put a No in column B, I want column A's figure to appear in
column D.
________

No doubt this is a simple calculation, any help would bee much
appreciated.

Many Thanks,

Mark


--
Muppet
------------------------------------------------------------------------
Muppet's Profile: http://www.excelforum.com/member.php...o&userid=10989
View this thread: http://www.excelforum.com/showthread...hreadid=381305

Seems pretty simple. Column C=IF(B1="yes",A1,"")

Is that what you want?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=381305

that'd be the daddy... thank you kindly.

Mark


--
Muppet
------------------------------------------------------------------------
Muppet's Profile: http://www.excelforum.com/member.php...o&userid=10989
View this thread: http://www.excelforum.com/showthread...hreadid=381305