sumproduct using DATE

**thoufik11** · 08-31-2021, 03:14 AM

Hi,

i have the following formula in my vba userform

Me.TextBox2.Value = Evaluate("SUMPRODUCT((Sheet1!$D$4:$AY$4= DATEVALUE(""" & ComboBox3.Value & """))*(Sheet1!$D6:$AY6))")

i am trying to get the sumproduct of the month in combobox. i am not getting any result.

the date is 1/7/2019

Capture1.JPG

**Kaper** · 08-31-2021, 04:36 AM

shouldn't it read:

Please Login or Register  to view this content.

**thoufik11** · 08-31-2021, 05:04 AM

yes. after editing that i still cant get the value.

And, how can i keep the format of the date the same. currently, i having cell A1 to have the date selected in Combobox. but the format keeps changing. the days and months digits are swapping.

Thank you

**Kaper** · 08-31-2021, 06:41 AM

Formatting date could be a problem depending on your system settings, etc. you may check values for instance

Please Login or Register  to view this content.

and instead of using

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

or possibly (if the msgbox showed day instead of month and month instead of day swap days and months

Please Login or Register  to view this content.

sumproduct using DATE

LinkBack

Thread Tools

Rate This Thread

Display

sumproduct using DATE

Re: sumproduct using DATE

Re: sumproduct using DATE

Re: sumproduct using DATE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] sumproduct adding date to time range only works for same date

[SOLVED] Index Sumproduct on date from date time

[SOLVED] Sumproduct formula, add up by date, average by date

If statment or sumproduct to change a value in a cell from todays date to date closed

[SOLVED] Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date

SumProduct using Date and Name

Sumproduct date help

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions