Helllo,
I have thirty sheets where I'm trying to count how many times a certain phrase in the range of D6
14. In those cells I have drop down list filled with 10 different options. For example ”release for service”, I would like to see how many times that appears on all 30 sheets on my master sheet. I already have the sheets names in a list called ”dayslist”. I was trying sum product and countif and keeping coming back with 0 or #ref. Thanks.