Tally Drop Down - NOT in a range - specific cells

[ahstigers]

I have a dropdown menu that I would like to keep a tally of - but I do not want a range - rather just specific cells. For example, I would not want C4:C15 - I would want the specific cells C4, C6, C8, etc. Is this possible? Any help is greatly appreciated!!!!

 

[SpillerBD]

Select the desired Cell using CTRL.
Name the Range using the Name Box.
Then Sum(NamedRange)
otherwise you use SUM(C4, C6, C8)

 

[ahstigers]

Select the desired Cell using CTRL.
Name the Range using the Name Box.
Then Sum(NamedRange)
otherwise you use SUM(C4, C6, C8)

That does not do what I am wanting to do. I don't need the cells added, I need different drop-downs tallied. There multiple options in each cell available via a dropdown - So, for cell C1, C3, C5 (etc), I would need to know the totals of which dropdown is selected. To do this, I had to use the countif function, but that only allows a range.