i need some help with a formula that i just cant get.

im making a list of items that includes their price, im then spliting
that price by 3 as 3 people are paying. after each items name is its
price and who has payed. i then have boxes with the total each person
has payed.

so some how i need a formula that will add to the persons total if
their name appears in the payed box.

sorry if i have made this more complicated than its needs to be

so far ive got :

=IF(OR(G11="callery"),B24=B24+D11,IF(OR(G11="dom") ,D24=D24+D11,IF(OR(G11="derek"),F24=F24+D11)))

but it doesent work


--
domhastings
------------------------------------------------------------------------
domhastings's Profile: http://www.excelforum.com/member.php...o&userid=24508
View this thread: http://www.excelforum.com/showthread...hreadid=381023