Custom Equations built off Index Match

Hi,

By all means I am no VBA expert. But I have been tasked with trying to figure this out. My goal here is to make custom equations like =unit_count() that will return the unit count based off of the two letter code contained in the referenced cell. The attached contains the two letter codes and in subsequent column headers, the values I seek to create custom equations for.

Can anyone start me off in the right direction?


Thanks
-C