Sumif?

M

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
 
Top