SOLVED

Iron Contributor

# Functions return the expected result at the real time.

Hi,

Could have any function that returns the expected result with criteria is a period of specific time.?

For example:

SUMIFS with criteria is a time between 7:AM and 10:AM of date 2023-01-28.

How can the function return the expected result at that real time?

=SUMIFS(Table1[sales],Table1[product],\$J\$3,Table1[units],\$J\$4,Table1[Date],\$I\$3)

Thank you.

2 Replies
best response confirmed by littlevillage (Iron Contributor)
Solution

# Re: Functions return the expected result at the real time.

``=IF(AND(NOW()>=I6,NOW()<=I7),SUMIFS(Table1[sales],Table1[product],\$J\$3,Table1[units],\$J\$4),"")``

Maybe with this formula? I6 and I7 contain =44954+7/24 and =44954+10/24 which is equivalent for 2023-01-28 7:00:00 and 2023-01-28 10:00:00.

# Re: Functions return the expected result at the real time.

It work correctly

Thanh you very much

1 best response

Accepted Solutions
best response confirmed by littlevillage (Iron Contributor)
Solution

# Re: Functions return the expected result at the real time.

``=IF(AND(NOW()>=I6,NOW()<=I7),SUMIFS(Table1[sales],Table1[product],\$J\$3,Table1[units],\$J\$4),"")``

Maybe with this formula? I6 and I7 contain =44954+7/24 and =44954+10/24 which is equivalent for 2023-01-28 7:00:00 and 2023-01-28 10:00:00.