Here's an abbreviated sample data from my sheet. There are 149 entries and I'm trying to pull out 6 for one of my summary sheet fields.
Shift Class_name
D1 Sigma
D2 Sigma
D1 Evaporator
D2 Evaporator
N1 Evaporator
D1 Sigma
If shift = "D1", then count number of cells containing "*Sigma*"
I need to nest something, here's my current formula:
=COUNTIF('Metals L2'!E$1:E$1131,"*sigma*")
which returns all sigma, not filtering other shifts out. The variations I've tried have added or multipied the 2 variables.
Am I in the right formula neigborhood?
Thanks for any help on this.
Shift Class_name
D1 Sigma
D2 Sigma
D1 Evaporator
D2 Evaporator
N1 Evaporator
D1 Sigma
If shift = "D1", then count number of cells containing "*Sigma*"
I need to nest something, here's my current formula:
=COUNTIF('Metals L2'!E$1:E$1131,"*sigma*")
which returns all sigma, not filtering other shifts out. The variations I've tried have added or multipied the 2 variables.
Am I in the right formula neigborhood?
Thanks for any help on this.