IF statements

  • Thread starter Thread starter Pascale
  • Start date Start date
P

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