Help Help Help Help!!!

Help Help Help Help!!!

Post by stapleton2 » Sat, 28 Jan 2006 10:17:04



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


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

Help Help Help Help!!!

Post by Norman Jon » Sat, 28 Jan 2006 10:29:27

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
> PLEASE PLEASE HELP!!>!!> >> >
> >-
> stapleton2>08
> --------------------------------------------------------------------->--
> stapleton2308's Profil>:
> http://www.yqcomputer.com/ ;78
> View this thread: http://www.yqcomputer.com/ ;90
>

 
 
 

Help Help Help Help!!!

Post by stapleton2 » Sat, 28 Jan 2006 10:41:09


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


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