Multiple Formula/Cell question

Ryon

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

Paul Newcome

Try this:

=COUNTIFS(...............................) - [Work in Progress]@row

Paul Newcome

Try this:

=COUNTIFS(...............................) - [Work in Progress]@row

Ryon

Thank you Paul, that worked perfectly once I applied it correctly!

Paul Newcome

Happy to help. 👍️