Referencing Other Sheets & Summing Text & Checkboxes
I am looking for the formula to sum text and value, but from another sheet. I tried using a previous formula that you guys helped me with but I can't get it to work.
I need to count the number of LM techs, Sub techs, and teams for a given job. The formula in the highlighted cells should return the number of techs assigned on a different sheet:
The sheet I am referencing looks like this:
If the text in column "FW 37" is "Cardinal Point" AND the check box in "LM Tech" column is NOT checked, it will return a "0".
If the text in column "FW 37" is "Cardinal Point" AND the check box in "LM Tech" column IS checked, it will return a "1". In this example, I should have "0" LM Techs and "3" Sub Techs.
Hope this makes sense! I can never tell if I am explaining all this correctly.
Help Article Resources
Check out the Formula Handbook template!