Problem with DATEVALUE and SUMPRODUCT

Folks,
I'm try to count projected sales using SUMPRODUCT and DATEVALUE and the answer I keep getting is #VALUE. Please see attached worksheet.
Thank you
CountSales.xlsm
Frank FreeseAsked:
Who is Participating?
 
Rgonzo1971Commented:
I suppose

this would be the formula

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

that implies that D2 is a date

Regards
0
 
Rgonzo1971Commented:
Hi,

You do not need datevalue if your dates are already dates and not text

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

Open in new window


Regards
CountSalesV1.xlsm
0
 
Frank FreeseAuthor Commented:
What if the dates came into the spreadsheet as text?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Frank FreeseAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for fh_freese's comment #a39918136

for the following reason:

got it now
thank you so much
0
 
Frank FreeseAuthor Commented:
whoops - - gave me credit not you
I'll ask that to be corrected
0
 
Frank FreeseAuthor Commented:
I incorrectly gave me points rather than to Rgonz01971
0
 
Rgonzo1971Commented:
HI,

As the Author already wrote, he wrongly gave credit to himself

pls correct

Regards
0
 
Frank FreeseAuthor Commented:
that should get you your points
0
 
Rgonzo1971Commented:
Thanks
0
 
Frank FreeseAuthor Commented:
My pleasure
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.