Here are my columns:
Column A has values representing screen resolutions such as "1366x768"
Column L has a formula to pull the first half of the numbers (the pixel width) out of the text string
Column N has my criteria; literal values that can go in the formula like ">=1600"
Column O has the SUMIF formula
I'd like to have only one formula so I can do away with the separate column for the number values.
Tried this but got "0" in the cell: