SUMIF (Excel '97)
=SUMPRODUCT(--(MONTH(A2:A100)=11),--(YEAR(A2:A100)=2007),B2:B100)
"Phendrena" wrote:
I want to sum a particular range using a date range as a criteria,
I have the dates in the worksheet formatted as dd/mm/yyyy.
How do i format this in the criteria?
For example dates for November would only be included anything else would be
ignored.
Thanks,
|