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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!