Basically i need to do the following. If i have a list of cells which
look like below:

£5000 Y

£10,000 N

£3,000 Y

£2,500 N

Total
£8000

What i want to be able to do is when i change the cell next to the
amount (which has the Y or N), i need the total cell at the bootom to
add up the only ones which have a Y next to it. Then, later if i was to
change it to a N, the total would then subtract that figure, giving the
new total
PLEASE PLEASE HELP!!!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=505590

Hi Stapleton.

See SUMIF in Excel Help.

Try something like:

=SUMIF(B1:B7,"=Y",A1:A7)


---
Regards,
Norman



"stapleton2308"
wrote in message
news:stapleton2308.229rfa_1138324801.3139@excelfor um-nospam.com...

Basically i need to do the following. If i have a list of cells which
look like below:

£5000 Y

£10,000 N

£3,000 Y

£2,500 N

Total
£8000

What i want to be able to do is when i change the cell next to the
amount (which has the Y or N), i need the total cell at the bootom to
add up the only ones which have a Y next to it. Then, later if i was to
change it to a N, the total would then subtract that figure, giving the
new total
PLEASE PLEASE HELP!!!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile:
http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=505590

your a genious!!!!! cheers mate!!!


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=505590