You can use the symbols Greater Than and Less Than signs in formulas in Excel. We’ll look at how to do this with the SUMIFS function, but the same logic can be applied to other functions and formulas as well.
Basic Signs
There are a few combinations of signs that can be used in Excel:
< Less Than
<= Less Than or Equal To
> Greater Than
>= Greater Than or Equal To
<> Not Equal To
Using a Static Number
You can combine the symbols above with a number that you type within a formula. For example, let’s say we have a table that shows monthly customer revenue data:
If we wanted to add up all the revenue from customers who had ordered 5 or more items, we could use a SUMIFS function to do that. For the criterion, we would need to type “>=5” (including the quotation marks). This returns a value of 950 (lines 4 and 5).
Using a Cell Reference
In addition to using a specific number reference within the formula, you can also use a cell reference. This allows you to easily change the criterion number or create a table and pull formulas down.
Using the same table as before, let’s say we wanted to show all cells that were greater than March 31, 2020. To do so, we would use the ">" symbol in our criterion. We then need to use the ampersand (&) sign and then reference the cell. This example would give us the number 250.
Comments