Date format changed to text format

Folks,
I would like to use the function offered to me below. In cell C2 I enter my date as text, 11/27/2013, In cells A3:A16 I have dates also formatted as text, same as in C2. Cell D3 holds the product number also formatted as text. The same formatting also applies to B3:B16, text.

{=SUMPRODUCT((DATEVALUE(D2)=$A$3:$A$16)*(D3=$B$3:$B$16))}

The result is #VALUE error.
Frank FreeseAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Angelp1ayConnect With a Mentor Commented:
Also I think you need a DateValue around your range in col A:
{=SUMPRODUCT((DATEVALUE(D2)=DATEVALUE($A$3:$A$16))*(D3=$B$3:$B$16))}

Open in new window

0
 
Angelp1ayCommented:
Is this literally just because your date is in C2 but your formula is actually referencing D2?
0
 
Frank FreeseAuthor Commented:
Great job! You nailed it there....
Thank you
0
All Courses

From novice to tech pro — start learning today.