Forum Discussion

Danielle Manthei's avatar
Danielle Manthei
Copper Contributor
Jun 06, 2018

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. 

Formulas & Functions
Need Help
  • Matt Mickle's avatar
    Matt Mickle
    Jun 06, 2018

    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?

     

     

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jun 06, 2018

    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?

     

     

Resources