Sumif?

[Muppet]

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

 

[MrShorty]

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

Is that what you want

 

[Muppet]

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

Mar