Quiz

  1. 1
    Beginner

    Which of the following is the correct syntax for the SUMIFS function?

  2. 2
    Beginner

    If no set of values satisfies the criteria in a SUMIFS formula (where the Sum_Range contains only numerical values), what will the result of the formula be?

  3. 3
    Beginner

    In the SUMIFS function, if criterion ranges are not of equal dimensions (i.e. same number of rows / columns), what error message would Excel display?