I have a document that has several filters attached to its headers. I want to create a formula that will basically count the VIEWABLE cells that meet the criteria.
here is the formula that i am having trouble with:
Basically what i want to do with this is count any cells that have the characters WL in it and display a total based on the viewing filter. Some of these cells have a WL2 or WL3 etc, i want to count as many WL's that are viewable.
I have "*"&"WL"&"*" in place for a wildcard for any WL's. (this works in a regular count if formula).
Any idea why i am not able to calculate them?