Scenario:

Six Columns, the first column is CITY and the other five are Fiscal Year
Columns (i.e., FY05, FY04, FY03, etc.) but not all cells under the fiscal
year columns are populated.

I want to count the populated cells under the fiscal year (FY) column if it
appears next to the cell with a specific city. (Under the city column, a
city_name can appear multiple times.)

Basically, if the city is X and the FY cell is populated, then count the
cell.

Any suggestion on how to create this formula/function?