Mathematical Functions in Google Sheets

Edit Answers
123456789101112131415161718
Across
  1. 1. Counts the number of non-empty cells (including text and numbers).
  2. 5. Counts the number of numeric values in the range.
  3. 7. Checks whether a given cell is empty and returns TRUE if the cell is blank and FALSE if it contains any value (including spaces, numbers, text, or formulas).
  4. 8. Returns the average of numbers that meet a single condition.
  5. 9. Returns the most frequently occurring value in a datase
  6. 12. Returns one value if a condition is TRUE and another value if it is FALSE.
  7. 14. Returns the largest number in a range that meets one or more conditions.
  8. 15. Returns the smallest number in a range that meets one or more conditions.
  9. 17. Returns the median (middle value) of a dataset.
Down
  1. 2. It is when you put multiple IF functions inside each other to evaluate multiple conditions.
  2. 3. Calculates the mean (average) of the numbers in the range.
  3. 4. Adds up values only if they meet multiple conditions.
  4. 6. Returns TRUE if all conditions are met, otherwise FALSE.
  5. 8. Returns the average of numbers that meet multiple conditions.
  6. 10. Returns TRUE if at least one condition is met, otherwise FALSE.
  7. 11. Returns the largest value in the range.
  8. 13. Adds up values if they meet a single condition.
  9. 14. Returns the smallest value in the range.
  10. 16. Adds all the numbers in the given range.
  11. 18. Checks multiple conditions and returns the first matching result.