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
Check out the Formula Handbook template!