Add condition to COUNTIFS

Answers
-
Hi all,
I have successfully created a countif formula that counts if a date appears in a column (RYZ101-301 enrollment Range X) that is the same date as in the Start row.
=COUNTIF({RYZ101-301 Enrollment Range 5}, Start@row) + COUNTIF({RYZ101-301 Enrollment Range 2}, Start@row)
Now I want to add an additional condition. Only count the value in RYZ101-301 Enrollment Range 2 and 5, if the cell in RYZ101-301 Enrollment Range 2 or 5 also has "On Treatment RYZ101" in a specified column "RYZ101-301 Enrollment Range 6" for the same row that has the date in Enrollment Range 2 or 5.
Is this possible @Paul Newcome , you seem to be a wiz at Countifs?
RYZ101 Enrollment range 6
RYZ101 Enrollment Range 2 or 5:
@Start:
My current formula without the condition for Enrollment range 6 comes up with "2" for May 22, 2023. My goal is to eliminate the 2nd May 22 since it is "On Treatment SOC".
Thanks,
Kathryn
-
You would just change the formula to a Countifs and add your range,criteria at the end
=COUNTIFS({RYZ101-301 Enrollment Range 5}, Start@row,{RYZ101-301 Enrollment Range 6},"On Treatment RYZ101") + COUNTIFS({RYZ101-301 Enrollment Range 2}, Start@row,{RYZ101-301 Enrollment Range 6},"On Treatment RYZ101")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!