Hi Stapleton.

See SUMIF in Excel Help.

Try something like:

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


---
Regards,
Norman



"stapleton2308" <stapleton2308.229rfa_1138324801.3139@excelforum-nospam.com>
wrote in message
news:stapleton2308.229rfa_1138324801.3139@excelforum-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
>