JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,532
- Office Version
- 365
- Platform
- Windows
Is there a way that I can use a formula other than a simple expression like "<0" in the criteria fields of functions like CountIfs?
In this table, column C has timestamps. I'd like to count how many have times before noon. In this example, there are 3 (C5, C7, & C9).
The expression "mod(C5,1)" (E5) will return the time portion of the date-time value. So if I can use that in the criteria field, I can get the count that I need as illustrated in F6. But all of the ways I tried either get errors or return zero.
In this table, column C has timestamps. I'd like to count how many have times before noon. In this example, there are 3 (C5, C7, & C9).
The expression "mod(C5,1)" (E5) will return the time portion of the date-time value. So if I can use that in the criteria field, I can get the count that I need as illustrated in F6. But all of the ways I tried either get errors or return zero.