• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

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
0
Frank Freese
Asked:
Frank Freese
  • 6
  • 4
2 Solutions
 
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
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now