Give this a try...

=SUMIF(B1:B200,"<sent",A1:A200)

Adjust the ranges to suit your needs.

Rick


"Ann" wrote in message
...
i need to count the sum of values in column A if column B < "sent" ...
sent
is text written into the cell
thanks in advance.