MS Excel | AverageIF and AverageifS

Поділитися
Вставка
  • Опубліковано 8 лис 2024

КОМЕНТАРІ • 8

  • @johnmakanete1685
    @johnmakanete1685 2 роки тому +4

    Great video sir.

  • @annerikunz1433
    @annerikunz1433 19 днів тому

    Mr Long is the only reason I'm passing CAT

  • @yrn78611
    @yrn78611 19 днів тому

    Very grateful for your videos Sir🙏🏽

  • @MosesKungu-c3y
    @MosesKungu-c3y Місяць тому +1

    those little jokes keeps me going😭

  • @myassina
    @myassina 11 місяців тому

    many thanks, most useful

  • @calv2192
    @calv2192 Місяць тому

    I have a #DIV/0! error 😢 please help

    • @MrLongITandCAT
      @MrLongITandCAT  Місяць тому

      Your cell reference maybe incorrect or your condition is picking up no matches. If say you are finding the average of students in grade 20, because there are no students in grade 20 there is nothing to total and nothing to count, so it is saying 0/0 for the average which is a divide by zero error.