hiya max thanx for the reply tried your sum but didn't work.
might be my fault, then again what i'm asking might be impossible!
your sum worked on the first base but when i entered a new figure in c1 it
changed g1 aswell i need it so once the sum has been added it stays and the
next time its added its added one row down (g2)(g3)(g4) so on... without
changing the figure in (g1)(g2)(g3)
--
deejay


"Max" wrote:

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