Counting formula for drop down list

[johnrobgray]

Hi all

I’ve had lots of help today and really appreciate

I’m looking for a little more on a drop down if anyone can help

I’ve got. Drop down box in I10 that has options to choose like Phone, Tablet, Sim etc

I want a formula in cell I40 that will just count how many times the drop down box is used between I10 and I39

I’m not bothered about what option was chosen from the drop down menu just the fact that the drop down was used so it would count as 1 each time

Thanks again

 

[johnrobgray]

Is anyone able to help with this one?

Lots of asks today I know