starryeyed
Board Regular
- Joined
- Jun 22, 2005
- Messages
- 221
I've tried, but I can't get it to work...
This is my formula
=SUMPRODUCT(--MONTH(Registrations!$K$3:$K$5000)=--MONTH(Helpdesk!$F$1),--Registrations!$K$3:$K$5000)
In Helpdesk!F1 I have 1/11/05
In registrariotns!K3:K5000 there's a list of dates, a few of which contain dates in November.
I've tried a countif, and I've tried the sumproduct, but both give the answer as 0 instead of 3. What have I done wrong?
This is my formula
=SUMPRODUCT(--MONTH(Registrations!$K$3:$K$5000)=--MONTH(Helpdesk!$F$1),--Registrations!$K$3:$K$5000)
In Helpdesk!F1 I have 1/11/05
In registrariotns!K3:K5000 there's a list of dates, a few of which contain dates in November.
I've tried a countif, and I've tried the sumproduct, but both give the answer as 0 instead of 3. What have I done wrong?