Help with Countifs formula with mutilple criteria on another sheet
Hello all,
I am trying to get the count for the number of times "04A" appears in a list that only applys to certain people in a certain area. I am pulling the infromation from a existing smartheet
The formula used is:
=COUNTIFS({04A}, Title@row, {Bucke & Shroud Repair Range 2}, "GP GSCGTVSGreenville CRCOE TPs & Liners (person name (204072509))", {Bucke & Shroud Repair Range 2}, "GP GSCGTVSGreenville CRCOE TPs & Liners ( person name(223024404))")
The answer should be 3 but i keep getting 0
What is is missing from this formula?
Thanks,
Reginald
Best Answer

HI @Reginald
Looking at the formula it appears you want to count when either of those person names flag up, but your formula required both to be present to count an item.
Using OR for either person names should fix it, heres a working formula.
=COUNTIFS({04A}, Title@row, {Bucke & Shroud Repair Range 2}, OR(@cell = "GP GSCGTVSGreenville CRCOE TPs & Liners (person name (204072509))", @cell = "GP GSCGTVSGreenville CRCOE TPs & Liners ( person name(223024404))"))
Hope that helps
Thanks
Paul
Answers

HI @Reginald
Looking at the formula it appears you want to count when either of those person names flag up, but your formula required both to be present to count an item.
Using OR for either person names should fix it, heres a working formula.
=COUNTIFS({04A}, Title@row, {Bucke & Shroud Repair Range 2}, OR(@cell = "GP GSCGTVSGreenville CRCOE TPs & Liners (person name (204072509))", @cell = "GP GSCGTVSGreenville CRCOE TPs & Liners ( person name(223024404))"))
Hope that helps
Thanks
Paul

It worked. Thanks a bunch Paul!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!