Is there a way to COUNT the cells in column A if the cell in column A equals "X" and the adjacent cell in column B equals "January"?
Google Sheets – Count Column If Criteria Met in Another Column
google sheets
Related Topic
- Google Sheets – Count Non-Blanks with Unique Values in Another Column
- Google-sheets – Google spreadsheet count words
- Google-sheets – Count the unique values in a Column based on criteria in 2 different columns
- Google Sheets – Count Lines in Column with Multiple Lines
- Google-sheets – How to count unique text in multiple column with mixture of number and text
- Google Sheets – Return Value from Column if Multiple Criteria are Met
- Google-sheets – Create serial count in column if adjacent cell is blank (Google Sheets)
- Google-sheets – Sum column value if any of several criteria is met in the adjacent column
Best Answer
In case you want to count the occurrences of 'X' (text) with 'January' in adjacent cell, try:
In case 'X' is actually a numeric value, and you want to sum all those numbers who have 'January' in the adjacent cell, try: