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