Drop down data retrieval

First post! I have a spreadsheet with a drop down list " Core or Non_Core"). As the supervisors pick the area of concern, I need a running total of the two, to always be visible on the spreadsheet. The attached is what I'm trying to get to work. Just can't remember the formula for counting the diferent lines within a data table.. Linking many different SS to the final total when I'm done.

Core 14
Non_Core 27

Thanks

Jack

Might be missing something but this looks like you need COUNTIF.

Regards, TMS

You could have, in B94, the formula:

=COUNTIF($A$2:$A$92,$A94)

and copy down. This saves having unique formulae for each area of interest.


Regards, TMS