Posted to microsoft.public.excel.misc
|
|
Help Help Help Help!!!
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
|