## Help Help Help Help!!!

### Help Help Help Help!!!

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

000 Y

0,000 N

,000 Y

,500 N

Total
000

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

--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.yqcomputer.com/

### Help Help Help Help!!!

Hi Stapleton.

See SUMIF in Excel Help.

Try something like:

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

---
Regards,
Norman

"stapleton2308" < XXXX@XXXXX.COM >

> 000 Y >> >> 0,000 N> >> > ,000 >
> ,500 >N >>
> Tot>l
> >00> >
> What i want to be able to do is when i change the cell next to >he
> 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 >he
> new to>al
> >-
> stapleton2>08
> --------------------------------------------------------------------->--
> stapleton2308's Profil>:
> http://www.yqcomputer.com/ ;78
> View this thread: http://www.yqcomputer.com/ ;90
>