I am trying to count the number of rows that meet several sets of criteria, but because of how my criteria is structured, rows may fall into both of these categories. I’m not sure how to subtract out those that do.

Here is what I have so far:

=COUNTIFS(Data10[name],$A$1,Data10[state],"CA", Data10[efc],"<=10000",Data10[gpa],">=3") + COUNTIFS(Data10[name],$A$1,Data10[state1011],"CA", Data10[efc],"<=4995",Data10[hsgpa],">=2")

I appreciate any help!

Thanks!