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 wrote in message
...
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 wrote in message
...
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" wrote in message
...
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 wrote in message
...
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