IF statements

[Pascale]

I am currently using the following formula

IF(MONTH(Complaints!G2:G350)=MONTH(B1), SUMPRODUCT.....

the only thing is, is the formula is counting everything regardless of
the month specified. The month in b1 is formatted as MONTH-YEAR
(Jul-04), the date in G2:G350 is formatted as dd/mm/yyyy. Is this
something to do with it not picking up the correct month. I have tried
changing the formatting with no luck on the formula results, as it is
still picking up all records. Is there another way to write the
formula???

Thanks

 

[RagDyeR]

You could have asked this in your original thread in the Functions group!

Anyway, why don't you include this within your SumProduct formula?

Try This:

=SUMPRODUCT((MONTH(Complaints!G2:G350)=MONTH(B1))*(Complaints!A2:A350>=2)*(C
omplaints!A2:A350<=4))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am currently using the following formula

IF(MONTH(Complaints!G2:G350)=MONTH(B1), SUMPRODUCT.....

the only thing is, is the formula is counting everything regardless of
the month specified. The month in b1 is formatted as MONTH-YEAR
(Jul-04), the date in G2:G350 is formatted as dd/mm/yyyy. Is this
something to do with it not picking up the correct month. I have tried
changing the formatting with no luck on the formula results, as it is
still picking up all records. Is there another way to write the
formula???

Thanks