I have a report I'm trying to build. I pull the data from an access query and am summarizing it in excel. My plan is for it to auto update everything when I refresh the data.
I think I need to nest a formula, and it's giving me a headache!. This formula shows all entires with "*sigma*", I also need it to look at Column A on the sheet and only count column E if Column A = "D1" (the shift at work), I'd then copy the working formula for "D2", "N1", "N2". The variations I have tried either add the D1 & Sigma or multiply them.
=COUNTIF('Metals L2'!E$2:E$1132,"*sigma*"
Thanks for your help!
I think I need to nest a formula, and it's giving me a headache!. This formula shows all entires with "*sigma*", I also need it to look at Column A on the sheet and only count column E if Column A = "D1" (the shift at work), I'd then copy the working formula for "D2", "N1", "N2". The variations I have tried either add the D1 & Sigma or multiply them.
=COUNTIF('Metals L2'!E$2:E$1132,"*sigma*"
Thanks for your help!