=SUMPRODUCT(--(ISNUMBER(2003_column)),2002_column)


--

Regards,

Peo Sjoblom


"Justine Burn via OfficeKB.com" wrote in message
...
HI. I need a formula that checks if there are numbers in both 2002 column
and 2003 column, and if so totals 2002 numbers. ie: if both years had a
sale figure in them then add 2002 number so I can see the retention rate
of
customers. Thanks for any help. J

--
Message posted via http://www.officekb.com