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
Bookmarks