SUMIFS et al Examples- Bigger or less than
SUMIFS et al Ex 6
In this example we want to automatically count how many months the Gross profit is negative and how many months are positive
- In E13, use COUNTIF to count how many numbers in row 10 are negative numbers. In this case the criteria needs to be in quotes e.g. “<0”
- In E14 use COUNTIF to count how many numbers are positive
et al Ex 7
In this example we want to avoid a ‘unique’ number being used twice.
- In Column G (yellow cells), create a formula that will check if Transaction ID (column B) for that row, is duplicated somewhere else in column B (that is the invoice number has been entered twice accidentally)
To see the full course contents click here.