Austin Lang
Board Regular
- Joined
- Sep 10, 2021
- Messages
- 51
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
Good morning,
Below is the formula that I am working with. My goal is to have the 2nd criteria be if the value in that cell is greater than zero. How do I enter that? What I have highlighted in red is my latest unsuccessful attempt.
Thank you!
Below is the formula that I am working with. My goal is to have the 2nd criteria be if the value in that cell is greater than zero. How do I enter that? What I have highlighted in red is my latest unsuccessful attempt.
Thank you!
MAXIFS(Form!$R:$R,Form!$A:$A,MasterData!AC5,Form!$AG:$AG,AG>0) |