Sumif or Sumproduct
 

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

=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

thanks but i only want it to add the 2002 column. your answer adds both
2002 and 2003. cheers

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

Are you sure that you tested this correctly. It seems to work correctly as I
understand your request.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Justine Burn via OfficeKB.com" wrote in message
...
thanks but i only want it to add the 2002 column. your answer adds both
2002 and 2003. cheers

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

You may want to post the formula you used.

I bet it differs from Peo's suggestion.

"Justine Burn via OfficeKB.com" wrote:

thanks but i only want it to add the 2002 column. your answer adds both
2002 and 2003. cheers

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

--

Dave Peterson