In column B, I have various codes, e.g. C1, C2, C3 and D. This represents a
Floor Plan to an apartment building.
In column L, I will be entering a C or S adjacent to one of the codes listed
above. This represent the "C"opper or "S"ilver upgrade packages that can be
purchased.
I need a formula that will look for all C1's and count how many C's are
entered. I can then adjust the formula to look for C2 and count how many C's
or S's are entered for C2 etc....My end result needed is to establish how
many Copper upgrades will be for each floor plan, and how many Silver
upgrades for each floor plan. I believe this will be an array formula,
combined with a countif but not sure how to lay it out. Please Help