seroberts242
New Member
- Joined
- Mar 9, 2012
- Messages
- 10
Hi,
I want to count filtered cells but I don't want the count to include cells that contain "x" or empty cells.
I use this formula to count filtered cells:
=SUBTOTAL(103,A2:A140)
I use this to count with the exception of cells that contain "x":
=COUNTIFS(A2:A140,"<>",A2:A140,"<>x")
I guess I'm trying to figure out how to get all of this into one formula..
Thanks in advance!
I want to count filtered cells but I don't want the count to include cells that contain "x" or empty cells.
I use this formula to count filtered cells:
=SUBTOTAL(103,A2:A140)
I use this to count with the exception of cells that contain "x":
=COUNTIFS(A2:A140,"<>",A2:A140,"<>x")
I guess I'm trying to figure out how to get all of this into one formula..
Thanks in advance!