Sumif or Sumproduct

[Justine Burn via OfficeKB.com]

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

[Peo Sjoblom]

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


--

Regards,

Peo Sjoblom


"Justine Burn via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> 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

[Justine Burn via 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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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