Formula Tweak
Hi - How to I adjust (add to) this formula so it sums Green and Gray for Clark Usher?
=COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, "Clark Usher", [Primary Status]1:[Primary Status]10, "Green")
Best Answer
-
Hi @Clark Usher,
You're halfway there!
If your data range is not going to get any larger then the following formula works:
=COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, "Clark Usher", [Primary Status]1:[Primary Status]10, "Green")+COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, "Clark Usher", [Primary Status]1:[Primary Status]10, "Gray").
If you wanted it to be able to take in any future data being added, then remove the numbers in the range so the formula looks at only columns:
=COUNTIFS([Primary Reviewer]:[Primary Reviewer], "Clark Usher", [Primary Status]:[Primary Status], "Green")+COUNTIFS([Primary Reviewer]:[Primary Reviewer], "Clark Usher", [Primary Status]:[Primary Status], "Gray").
This is assuming you are only looking at Primary Reviewer - you would need to expand the formula further if also counting secondary reviewer.
Hope this helps, if you have any questions please ask! 😊
Answers
-
Hi @Clark Usher,
You're halfway there!
If your data range is not going to get any larger then the following formula works:
=COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, "Clark Usher", [Primary Status]1:[Primary Status]10, "Green")+COUNTIFS([Primary Reviewer]1:[Primary Reviewer]10, "Clark Usher", [Primary Status]1:[Primary Status]10, "Gray").
If you wanted it to be able to take in any future data being added, then remove the numbers in the range so the formula looks at only columns:
=COUNTIFS([Primary Reviewer]:[Primary Reviewer], "Clark Usher", [Primary Status]:[Primary Status], "Green")+COUNTIFS([Primary Reviewer]:[Primary Reviewer], "Clark Usher", [Primary Status]:[Primary Status], "Gray").
This is assuming you are only looking at Primary Reviewer - you would need to expand the formula further if also counting secondary reviewer.
Hope this helps, if you have any questions please ask! 😊
-
Awesome, thought I was close, it was the + sign to add the nested countifs I was unsure of.
Also, thanks for the further explanation on the data range!
Cheers Clark
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 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!