Hello,
I have a pretty basic/standard COUNTIFS formula which is working great. However, I am tying to add one more criteria to this formula, and when I do, only the first cell works. When I try to paste the formula down, it turns all too zero. I know that is not appropriate just by knowing the data. Here is my current formula.
First off, I couldn't figure out how to do the OR.... "Completed", "Not Started", "In Progress"....so I just spelled it out three times. That is not really my question, but if you could adjust that, just let me know.
OK. I am trying to add the following criteria. [Testing 2020] tab; column L named 'Team'. I have another tab [Teams] with a list of teams in A1:A5. I only want hte count if to count this records if column L - Team is found within my Team list from Teams A1=A5.
I have a pretty basic/standard COUNTIFS formula which is working great. However, I am tying to add one more criteria to this formula, and when I do, only the first cell works. When I try to paste the formula down, it turns all too zero. I know that is not appropriate just by knowing the data. Here is my current formula.
=COUNTIFS('Testing 2020'!$D:$D, "Testing", 'Testing 2020'!$AB:$AB, "*"&G8&"*", 'Testing 2020'!$K:$K, "*"&Q8&"*", 'Testing 2020'!$G:$G, "Completed")+ COUNTIFS('Testing 2020'!$D:$D, "Testing", 'Testing 2020'!$AB:$AB, "*"&G8&"*", 'Testing 2020'!$K:$K, "*"&Q8&"*", 'Testing 2020'!$G:$G, "Not Started")+ COUNTIFS('Testing 2020'!$D:$D, "Testing", 'Testing 2020'!$AB:$AB, "*"&G8&"*", 'Testing 2020'!$K:$K, "*"&Q8&"*", 'Testing 2020'!$G:$G, "In Progress") |
First off, I couldn't figure out how to do the OR.... "Completed", "Not Started", "In Progress"....so I just spelled it out three times. That is not really my question, but if you could adjust that, just let me know.
OK. I am trying to add the following criteria. [Testing 2020] tab; column L named 'Team'. I have another tab [Teams] with a list of teams in A1:A5. I only want hte count if to count this records if column L - Team is found within my Team list from Teams A1=A5.