Thread: How do I do a count sum that ignores duplicate items

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

--

HTH

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


"Robin Faulkner" <Robin Faulkner@discussions.microsoft.com> wrote in message
news:DB1EE2F6-77E2-4185-B672-8F8EC808DC92@microsoft.com...
>

If you mean sum, then you need

=SUMPRODUCT(1/(COUNTIF(A1:A100,A1:A100)),A1:A100)

--

HTH

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


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23sL%23uaOFFHA.3120@TK2MSFTNGP12.phx.gbl...
> =SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Robin Faulkner" <Robin Faulkner@discussions.microsoft.com> wrote in
message
> news:DB1EE2F6-77E2-4185-B672-8F8EC808DC92@microsoft.com...
> >
>
>