Aggregate Counta with criteria

[cgampon]

I have a table with a column that contains text. I'd like to be able to use the Aggregate function to count only certain text string (ie; "Split level") and return the count for just the visible/unfiltered results.

I've tried...:

Aggregate(3,7,Tbl_Master[NOTE]="Split level")

This returns...: #Value

If I highlight the Tbl_Master[NOTE]="Split level" and press [F9], I see all of the true and false values for the column. I can't figure out how to return a count of all of the true values.

Any help will be greatly appreciated.

Cg

[Jonmo1]

Aggregate only supports criteria arrays (range="x") with options 14+

I suggest adding a helper column to the table, call it Visible or whatever
In that column put
=AGGREGATE(3,7,[@NOTE])

Then use
=COUNTIFS(Tbl_Master[NOTE],"Split level",Tbl_Master[Visible],1)

[cgampon]

THANK YOU FOR THE PROMPT REPLY...

I tried the Countifs statement. I get an error highlighting the Tbl_Master[Visible] part of the formula.

I'M AFRAID I WILL NEED MORE HELP...

- I'm not familiar with the "VISIBLE" state.
- I am also not familiar with the 1 used for criteria.

? is the Visible state part of a list of states that a table/field/record can be in?
? is the "1" used as criteria refer to a logical state of 1=true 0=false?

[Jonmo1]

You add a column to the table
I just used Visible as an example for the Header text of that helper column.
In the helper column, put the aggregate formula I posted.
The aggregate will return 1 if there is a value in the Note column of that row AND that row is visible
It will return 0 otherwise.
Then use the Countifs function I posted