Subtracting CountIF from CountIF

[Tgirl22]

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!!!

 

[adam087]

Check out the COUNTIFS forumla.
=COUNTIF(Deliverables!T:T, TRUE)-COUNTIFS(Deliverables!T:T, TRUE, Deliverables!H:H, "DBA")-COUNTIFS(Deliverables!T:T, TRUE, Deliverables!H:H, "Data Support")

Welcome to the board

/AJ

 

[Momentman]

WELCOME TO THE FORUM

What of a countifs

=COUNTIFS(Deliverables!T:T,"TRUE",Deliverables!H:H,"<DBA",Deliverables!,"<>Data Support")

 

[Tgirl22]

Neither one of those formulas worked??

 

[Momentman]

It's very likely we don't have a true picture of what your data looks like or what your request really is. Maybe if you could help with that