SUMIFS et al Examples- Bigger or less than

Please purchase the course before starting the lesson.

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.

Lesson tags: vlookup
Back to: Advanced Excel Course > SUM, COUNT, AVERAGE IFS