Multiple Formula/Cell question
Hello again,
I have used the following formula and it gives me part of what I am looking for. Is it possible to add to it to subtract the value from another cell (also obtained by a formula)?
=COUNTIFS({RBI CAPA Tracker Year}, Year@row, {RBI CAPA Tracker Dept}, [Primary Column]@row, {RBI CAPA Tracker On Time}, [Column6]$1)
The "On Time" number is technically correct as they are not closed, but I need "On Time Closed" not just all "On Time". I was hoping to be able to add to the formula to be able to subtract the value from the "Work in Progress" column but haven't been able to get anything to work.
Is there a way to do this?
Thank you!
Ryon
Best Answer
-
Try this:
=COUNTIFS(...............................) - [Work in Progress]@row
Answers
-
Try this:
=COUNTIFS(...............................) - [Work in Progress]@row
-
Thank you Paul, that worked perfectly once I applied it correctly!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!