J
JOSA
Help please
I'm trying to count the number on items sold on a particular month
using SUMPRODUCT but I'm getting the wrong answer
This is what I use for each month (Feburary) for this example:
=SUMPRODUCT((MONTH($L$2:$L$5973)=2)*(YEAR($L$2:$L$5973)=2007)*($U$2:$U$5973=$A4))
The item is in A4 the date is in column L and in Column U are all the
mixed items.
I have checked the date format and its ok.
Can any one help please?
Thanks
josa
I'm trying to count the number on items sold on a particular month
using SUMPRODUCT but I'm getting the wrong answer
This is what I use for each month (Feburary) for this example:
=SUMPRODUCT((MONTH($L$2:$L$5973)=2)*(YEAR($L$2:$L$5973)=2007)*($U$2:$U$5973=$A4))
The item is in A4 the date is in column L and in Column U are all the
mixed items.
I have checked the date format and its ok.
Can any one help please?
Thanks
josa