COUNTIF based on Data Validation dropdown choice

Ok. I have a table of values. In Column A1-A368 I have 27 regional office names (chicago, LA, so on and so forth) appearing multiple times. In columns B-AA (and from rows 1-389) I have values of A, B, C, or D so that each regional office name in column A has values in each row from B-AA. I want to look through Column A and find all the names of one regional office (I.E. chicago) and find out how many times the value of just one value (in this case A) is in Column B for JUST THAT OFFICE and that answer will go in cell B 369. Then I would have a separate formula to do the same in column B. So on and so forth.

Now...the tricky part is.....what I want to do is in Cell A 369 have a validation list so whatever value I choose from the List (say I choose Chicago), the formula in cell B389 will adjust and only count for the value in A389

is this possible?

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Your attached workbook does not match the description in post #1.