Forum Discussion
Solved
Copy Data to Other Sheets' Columns Based on Criteria
Hello, I am trying to calculate the number of interviews based on each Specific Region. There are going to be multiple responses for each interview, so I was looking to capture any cell that ha...
Hey Danielle-
Hope you're doing well. Please try putting this formula in cell D3 of your worksheet:
=COUNTIFS(Sheet1!$C$10:$C$500, A1,Sheet1!$H$10:$H$500,"<>")
I believe that's what you're looking for as a result. If not, can you please provide a little more information?
Hey Danielle-
Hope you're doing well. Please try putting this formula in cell D3 of your worksheet:
=COUNTIFS(Sheet1!$C$10:$C$500, A1,Sheet1!$H$10:$H$500,"<>")
I believe that's what you're looking for as a result. If not, can you please provide a little more information?
That worked! Thanks!