software

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: www.excelforum.com/member.php...oamp;userid=30878
View this thread: www.excelforum.com/showthread...hreadid=505590Hi Stapleton.

See SUMIF in Excel Help.

Try something like:

=SUMIF(B1:B7,quot;=Yquot;,A1:A7)---
Regards,
Norman
quot;stapleton2308quot; gt;
wrote in message
news:stapleton2308.229rfa_1138324801.3139@excelfor um-nospam.com...
gt;
gt; Basically i need to do the following. If i have a list of cells which
gt; look like below:
gt;
gt; ?5000 Y
gt;
gt; ?10,000 N
gt;
gt; ?3,000 Y
gt;
gt; ?2,500 N
gt;
gt; Total
gt; ?8000
gt;
gt; What i want to be able to do is when i change the cell next to the
gt; amount (which has the Y or N), i need the total cell at the bootom to
gt; add up the only ones which have a Y next to it. Then, later if i was to
gt; change it to a N, the total would then subtract that figure, giving the
gt; new total
gt; PLEASE PLEASE HELP!!!!!
gt;
gt;
gt; --
gt; stapleton2308
gt; ------------------------------------------------------------------------
gt; stapleton2308's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30878
gt; View this thread: www.excelforum.com/showthread...hreadid=505590
gt;

your a genious!!!!! cheers mate!!!--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: www.excelforum.com/member.php...oamp;userid=30878
View this thread: www.excelforum.com/showthread...hreadid=505590