• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Alice Bumgarner, Moderator

Question: “I need help writing an Excel formula that counts information from
two columns. I want the result to be the total number of items that
meet two conditions.

Example: Imagine a spreadsheet where Column A records
location and Column B records a number. I want to calculate how many
entries for Location Such-and-Such also have a number in Column B that
is less than 15 [=COUNTIF(B1:B25,”<15”]. How would I write that
formula?”  — Valerie


Page 44 of 44« First...102030...4041424344