PatRichard
New Member
- Joined
- Dec 29, 2018
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
I'm trying to use countif to figure out how many rows have two cells that added together are greater than another value. I know for a single column, something like
works fine. But I want the sum of SiteInfo[Number of Users] + SiteInfo[Shared Devices] as the criteria, and just can't seem to find something that works. The closest I've come is counting the number of rows where either cell is < Data!E51. Thoughts?
Excel Formula:
=COUNTIF(SiteInfo[Number of Users],"<"&Data!E51)