Alice Bumgarner, Moderator — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Page 86
  • 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

{ 0 comments }

Page 86 of 86« First...102030...848586