• 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 86 of 86« First...102030848586