Solved

# Problem with DATEVALUE and SUMPRODUCT

Posted on 2014-03-10
366 Views
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
Question by:Frank Freese
• 6
• 4

LVL 49

Assisted Solution

Rgonzo1971 earned 500 total points
ID: 39918101
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))
``````

Regards
CountSalesV1.xlsm
0

Author Comment

ID: 39918136
What if the dates came into the spreadsheet as text?
0

LVL 49

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 39918150
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

Author Comment

ID: 39918210
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

Author Comment

ID: 39918204
whoops - - gave me credit not you
I'll ask that to be corrected
0

Author Comment

ID: 39918211
I incorrectly gave me points rather than to Rgonz01971
0

LVL 49

Expert Comment

ID: 39918214
HI,

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

pls correct

Regards
0

Author Closing Comment

ID: 39918217
that should get you your points
0

LVL 49

Expert Comment

ID: 39918220
Thanks
0

Author Comment

ID: 39918272
My pleasure
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…