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/

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

>

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

>

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

--

stapleton2308

------------------------------------------------------------------------

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

View this thread: http://www.yqcomputer.com/

2. HELP HELP HELP HELP HELP HELP

3. help help help help help help win98 to xp professional

4. !!!!!!!HELP HELP HELP HELP HELP!!!!!!!!!!!!!!!!!

5. Forum Administrators - HELP, HELP, HELP, HELP, HELP

8. Backup and Restore Problem - HELP, HELP, HELP, HELP

10. LOST PRODUCT KEY, HELP HELP HELP HELP

11. seeking solution for DataGrid, help, help, help, help

3 post • Page:**1** of **1**