In G1 enter =IF(AND(A1="January",B1="Paid"),C1,"") and in G2 enter
=IF(AND(A1="Jan",B1="Paid"),C1,"")

Regards,
The Code Cage Team
www.thecodecage.com/forumz

"confused deejay" wrote:

hiya all
i'm trying to make 2 dropdown lists which when added with a figure in a 3rd
cell copies the cell into another column.

i.e
a1=(dropdown"january") b1=(dropdown"paid") c1=("manual input"100)

in g1 i want the total 100(c1) only if a1& b1 is set above.

but what i also want is if a1=jan,b1=paid,c1=200 and g1 is full(1) then
enter 200(c1) into g2

please help.
--
deejay

--
deejay