Trying to use a formula in the summary sheet with an AND to look at values from two columns
Hello,
I've searched and was not able to find this exactly, and looking over the formula guides I still am not sure how to do this. I am trying to set up a summary field in the sheet summary that looks at the values of two columns and validates both are present to count the field.
Here is the best I could do to try to get it, but it tells me it is unparseable:
=COUNTIF(AND((Risk:Risk, "Not Scheduled"), ([Client Facing]:[Client Facing], ISBOOLEAN(Done1))))
I am trying to look at the values of a single dropdown column RISK and the checkbox column CLIENT FACING and only count the value for each row if:
- value in RISK column = "Not Scheduled"
- CLIENT FACING is a checked checkbox
From what I can tell, the COUNTIF is still looking for the criterion, but since it is an AND statement, the criterion is within the AND grouping.
Where am I going wrong with this?
Thanks for any help.
Best Answer
-
Try this...
=COUNTIFS(Risk:Risk, "Not Scheduled", [Client Facing]:[Client Facing], 1)
Answers
-
Try this...
=COUNTIFS(Risk:Risk, "Not Scheduled", [Client Facing]:[Client Facing], 1)
-
Worked like a charm. Thank you very much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!