Hi

I was wondering if it were possible to do the following;

I have a cell picking up a total but I need it to subtract amounts
from a possible 5 other cells. The problem is that the cells may or may
not need to be subtracted. There is a list box to the left of the dollar
amounts that need to be subtracted and I only need to subtact them if
the same list box item is choosen.
For example I have total cash in Cell H5 now i need to subtract amounts
from F21-F24 but only if the listbox next to them has Cash selected.

Any Help Would Be Appreciated.

thank you

Redwings04


--
redwings04
------------------------------------------------------------------------
redwings04's Profile: http://www.excelforum.com/member.php...o&userid=24897
View this thread: http://www.excelforum.com/showthread...hreadid=384328