SumIf or SumProduct or If statements

[Guest]

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!D3200="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

 

[Bob Phillips]

Could column a be real dates?

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

--

HTH

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

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!D3200="Sales"),Income!F
3:F200) - this just generates a 0 [there is data in the referenced cells].

 

[Guest]

Hi Bob,

Many thanks - spot on.

Cheers!,

Mike

Could column a be real dates?

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

--

HTH

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

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!D3200="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

 

[Bob Phillips]

Great. It was a lucky guess <g>

Bob

Hi Bob,

Many thanks - spot on.

Cheers!,

Mike

Could column a be real dates?

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

--

HTH

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

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!D3200="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