On the face of it, this might suffice
In G1: =IF(AND(A1="january",B1="Paid"),C1,"")
In G2: =IF(G1=200,G1,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"confused deejay" wrote:
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