Counting Function referencing both numbers and phrases

[akhockey]

I am attempting to craft a spreadsheet that will count certain numbers in columns when a phrase appears in another column but same row.

The essential information is in two Columns, A & B. Column A will list words such as "ABC", "Water", "PK". Column B will list years.

For example, I want to count how many times 2004 appears where ABC is in the same row.

I can then modify the formula to count how many "ABC" there are or sort by different years.


I have used countif for sorting this information by a single variable, i just don't know how to do it for multiple variable in multiple columns or cells. This spreadsheet is approx. 300 rows. Any help is appreciated. Thanks.