Using CountIfs with an and condition summarizing data from sheet 1 to sheet 2

Options
Ira K
Ira K ✭✭
in Formulas and Functions


I have a sheet that list PC that has been deployed to a user at a given location The detail sheet has the suer location and a checkbox for when the PC has been deployed. On a summary sheet, I am tracking for each location, how many deployments were planned and how many have been completed. I am trying to use CountIfs abut not finding the right combination for it. I keep getting Invalid Ref returned.


=COUNTIFS({Deployment Tracking Sheet Location}, =Site@row, {Deployment Tracking Sheet Deployed} = 1)

Summary Sheet

image.png

Detail Sheet

image.png


Tags:
· Share on FacebookShare on Twitter

Best Answer

  • KPH
    KPH Community Champion
    Answer ✓

    Hi

    It looks like you have a tiny syntax issue. Try adding comma after {Deployment Tracking Sheet Deployed}

    =COUNTIFS({Deployment Tracking Sheet Location}, =Site@row,{Deployment Tracking Sheet Deployed}, =1)

    · Share on FacebookShare on Twitter

Answers

  • KPH
    KPH Community Champion
    Answer ✓

    Hi

    It looks like you have a tiny syntax issue. Try adding comma after {Deployment Tracking Sheet Deployed}

    =COUNTIFS({Deployment Tracking Sheet Location}, =Site@row,{Deployment Tracking Sheet Deployed}, =1)

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!