Could column a be real dates?

=SUMPRODUCT(--(TEXT(Income!A3:A200,"mmmm")="January"),--(Income!D3:D200="Sal
es"),Income!F3:F200)

--

HTH

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


"Mike W" <Mike W@discussions.microsoft.com> wrote in message
news:B7882ADA-C0A0-4B88-BA9A-0045BB0198D4@microsoft.com...
> I am trying to do the following:
>
> A Date Column =mmmm
> B Detail column=
> C Totals column=
>
> I would like reference the above sheet [titled Income] from a cell in a
> totals sheet thus:
> If A=January & B=Sales then Sum C.
>
> I have tried the following:
>
>
=SUMPRODUCT(--(Income!A3:A200="January"),--(Income!D3:D200="Sales"),Income!F
3:F200) - this just generates a 0 [there is data in the referenced cells].
>
> I just can't seem to get this.
>
> Any ideas out there?
>
> Many thanks!
>
> Mike W