Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Jan 27, 2023
Solved

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)

 

Any ideas, please.

Thank you.

 

2 Replies

No RepliesBe the first to reply

Resources