Functions return the expected result at the real time.

[littlevillage]

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)

Any ideas, please.

Thank you.

[#2 · Accepted solution]

@littlevillage 

=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.

[#3]

@OliverScheurich 

It work correctly

Thanh you very much