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 had data for that region. The data will be on tab 1, the results on tab 2. Current trouble spot highlighted in yellow.
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?
2 Replies
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!
