Help Help Help Help!!!

[stapleton2308]

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!!!!!

[Norman Jones]

Hi Stapleton.

See SUMIF in Excel Help.

Try something like:

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


---
Regards,
Norman



"stapleton2308" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[stapleton2308]

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