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