Sumproduct usage?
Hi,
For a given date
=SUMPRODUCT((D1:D20=DATE(2009,12,24))*(M1:M20="And y"))
Over a range of dates
=SUMPRODUCT((D1:D20=DATE(2009,12,23))*(D1:D20<=DA TE(2009,12,24))*(M1:M20="Andy"))
In practice I would use cell ref's for the criteria
=SUMPRODUCT((D1:D20=A1)*(M1:M20=A2))
Mike
"Destrachan" wrote:
My brain's on overload at the moment, so I'm turning to you guys for
help. I need help w/ a formula that will count the number of sales
that someone had based on a certain date...I thought I could use
sumproduct, but I'm beginning to wonder if I was wrong about that.
The relavant columns are D & M.
Col D Col M
12/24/2009 Andy
12/24/2009 Charles
12/24/2009 Andy
12/25/2009 Charles
.
|