SumIf or SumProduct or If statements

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!F3: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

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

Hi Bob,

Many thanks - spot on.

Cheers!,

Mike


"Bob Phillips" wrote:

> 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
>
>
>

Great. It was a lucky guess <g>

Bob


"Mike W" <MikeW@discussions.microsoft.com> wrote in message
news:F987D8D7-0F69-4FD5-ACF3-7067975FA104@microsoft.com...
> Hi Bob,
>
> Many thanks - spot on.
>
> Cheers!,
>
> Mike
>
>
> "Bob Phillips" wrote:
>
> > 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
> >
> >
> >