Countif using totals of two named columns

[PatRichard]

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

=COUNTIF(SiteInfo[Number of Users],"<"&Data!E51)

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?

 

[Cubist]

Not sure if I am misinterpreting what you are saying but that formula will count it if either of the value columns are not blank.

I'm just thinking about it wrong.

We tell the customer that no cells in the workbook should be empty for any site (row) containing data.

If that's the case you can try...

=SUM((SiteInfo[Number of Users]+SiteInfo[Shared Devices]<Data!E51)*(SiteInfo[Site name]<>""))