New to all of this so please bare w/me..
I am trying to write a formula and I think CountIF is the right one to use, but I am stuck.
Basically I am wanting the formula to count how many items there are after filtering on 3 columns.
In column T there are 169 items that are true and I used this formula - =countif(Deliverables!T:T,"TRUE")
But of those 163 I need to remove in column H anything that says DBA or Data Support.
How do I do this?
Thanks!!!
I am trying to write a formula and I think CountIF is the right one to use, but I am stuck.
Basically I am wanting the formula to count how many items there are after filtering on 3 columns.
In column T there are 169 items that are true and I used this formula - =countif(Deliverables!T:T,"TRUE")
But of those 163 I need to remove in column H anything that says DBA or Data Support.
How do I do this?
Thanks!!!