Count if highlighted or other criteria

So I'm trying to get counts of specific criteria and the totals are not working.
The criteria are:

count {field} if it says MHA Missing
count {field} if it's highlighted yellow
count {field} if it's >=2.999

any ideas?
Thanks

So I was able to get some totals based on summing formulas like:

If{@New MHA order}="MHA Missing" Then 1 else 0

if{@datediff 2}>=2.5
and{@datediff 2}<=2.998 then 1 else 0

running total for >=3
evaluate - on change of group
rest - never

I created parameters to select clinicians which range from 1 - 259 clinicians. I tested the totals for 1 clinician and 2 clinicians but when I select all clinicians and export it to excel and compare the totals they don't match except for client count.

Client count = 6522
Missing MHA = 968 (excel 845)
Due Date Approaching = 531 (excel 385)
MHA Update Due = 480 (excel 478)

Please help!

New update:
The totals are counting suppressed data. What I'm confused about is there's no fields in my suppressed sections. When I put the "clinician" field in the details section, I see that there are multiple clinicians attached to the client which I'm guessing is where these totals are being skewed.

Is there a way to ignore suppressed data?

Just because something suppressed in CR, it is still there.  If you do not want it to count then that same criteria needs to be in your running total (or formula is you are going that route).

So I suppressed my details section by right clicking and suppressing in Design. For my totals, I have two summaries and a running total:
If{@New MHA order}="MHA Missing" Then 1 else 0

if{@datediff 2}>=2.5
and{@datediff 2}<=2.998 then 1 else 0

running total for {@>=3}
evaluate - on change of group (group #1 PATID)
reset - never

Is there a way to ignore suppressed data in these formulas?
Thanks

What is the criteria for not including a value in a running total?  That will have to be included in the formula so that the running total does not happen.

I don't have a criteria. Right now I'm doing formulas like:
if{@datediff 2}>=3 then 1 else 0

and then I do a sum of that in my running total.

Again, just remember that suppressing a field, group, etc. does not remove it from the report, just hides it.

So running totals have to set up so that you are only counting what you want, not what you see.

kevlray is absolutely correct, don't confuse data visibility with its existence and the inclusion of it in summary data.
Since you are using Running totals, just use the distinct count on your patient id using your criteria not a "1 or 0" result sum.