willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
Re: Countif- Visible Cells in Filter mode
Hello, I hope someone could help me with a formula I have.
I am looking to count any cells that contain "IAR" in range: A4:A10000
My current formula is: =COUNTIF(A4:A1000,"*IAR*")
This counts everything from A4 down that contains "IAR", however when a filter is applied I need it to count only the visible cells.
I have tried: =SUMPRODUCT(SUBTOTAL(3,OFFSET(A4:A1000,ROW(A4:A1000)-MIN(ROW(A4:A1000)),,1))*(A4:A1000="*IAR*")) and it gives a result as 0 instead of 219
Thank you to anyone who can help!!
Carla
Hello, I hope someone could help me with a formula I have.
I am looking to count any cells that contain "IAR" in range: A4:A10000
My current formula is: =COUNTIF(A4:A1000,"*IAR*")
This counts everything from A4 down that contains "IAR", however when a filter is applied I need it to count only the visible cells.
I have tried: =SUMPRODUCT(SUBTOTAL(3,OFFSET(A4:A1000,ROW(A4:A1000)-MIN(ROW(A4:A1000)),,1))*(A4:A1000="*IAR*")) and it gives a result as 0 instead of 219
Thank you to anyone who can help!!
Carla
Last edited: