SUMPRODUCT With Dates

[meseleto]

Hello everyone,

I am having issues with SUMPRODUCT on a worksheet I have. How do I have excel evaluate the criteria based off of the displayed value instead of the formula? If I override the formula by hard-keying the date and time, it works instantly! However, I need it to work without having to do that for every single line since the worksheet does a lot of VLOOKUPS to organize the data in a certain way I need to look at it.

Please Login or Register  to view this content.

Where BW is a date that is referencing another worksheet that is the result of VLOOKUPS organizing data in a way I can't change easily. Again, if I were to go through each line in BW and hard key the same date and time, it works automatically!

Thanks all!

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[meseleto]

This file had so many linked worksheets that I didn't know how to desensitize all that data without spending hours and hours. I ended up getting it to work all on my own last night!

[TMS]

Ok, might have been an idea to let us know sooner, but no worries, no time wasted

[meseleto]

Whoops, sorry about that! Last night was 4-5am for me, I tried that Death Coffee for the first time and holy crap!