Hi there,

I’m trying to wrap my head around the dropdown menu function in Excel.

I’m using it this year to track which tasks were done on how many days.

F.e. the picture below are all dropdown cells. 

Per day I add tasks per zone / category / detail / how many people worked on it. 

After two months I want to know:

How many people worked on the food fronts: how many days / how many people?

I’ll add a filter on the column detail to search for the food fronts, but I want to be able to count the amount of people worked on it. 

Does there exist a formula to count the amount of cells selected in one dropdown? 

In this example the formula would say: 6 people worked on food fronts that day. 

Many thanks! 

​Hi there, I’m trying to wrap my head around the dropdown menu function in Excel.I’m using it this year to track which tasks were done on how many days. F.e. the picture below are all dropdown cells. Per day I add tasks per zone / category / detail / how many people worked on it.  After two months I want to know:How many people worked on the food fronts: how many days / how many people? I’ll add a filter on the column detail to search for the food fronts, but I want to be able to count the amount of people worked on it.  Does there exist a formula to count the amount of cells selected in one dropdown? In this example the formula would say: 6 people worked on food fronts that day.  Many thanks!    Read More

​