Frank Freese
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Accepted answer: 0 points for fh_freese's comment #a39918136
for the following reason:
got it now
thank you so much
ASKER
whoops - - gave me credit not you
I'll ask that to be corrected
I'll ask that to be corrected
ASKER
I incorrectly gave me points rather than to Rgonz01971
HI,
As the Author already wrote, he wrongly gave credit to himself
pls correct
Regards
As the Author already wrote, he wrongly gave credit to himself
pls correct
Regards
ASKER
that should get you your points
Thanks
ASKER
My pleasure
ASKER