CountIf on visible rows only

[DarkJester89]

I have a formula

=COUNTIF(Table1[Column11],10)+COUNTIF(Table1[Column11],11)

Combined countif to look for 10 or 11 in the table

It's on a filtered table, but is there a way to convert this to count only visible rows? I've tried various subtotal formulas but can't get it to work. Thank you in advance.

 

[DarkJester89]

Ok how about

=COUNTIFS(Table1[Column11],">9",Table1[IsVisible],1)

I inputted this and it's still only recognizing the first table entry and errors out.

I uploaded it a drive, cell AL16, "formula parse error"

Workbook

Thanks again for your time.

 

[Fluff]

You don't have a column called IsVisible, it's called Column12, so you need to change the formula accordingly.

 

[DarkJester89]

You don't have a column called IsVisible, it's called Column12, so you need to change the formula accordingly.

The formula works changing it to column 12. My original intent ? was if it was possible to convert it to only count rows in the table that are visible, so for example if I hide a row, it'll reduce it by one.

 

[Fluff]

That's exactly what it does.

 

[DarkJester89]

That's exactly what it does.

I had to reupload my workbook, it looks like someone went in haywired the formulas I put in.

With the formulas above, I hid row 2-10, and it's still counting four and should only count 1 (the visible row with >9, 10 or 11).

Workbook

Thanks for your patience, got swamped at work.

 

[Fluff]

As you are manually hiding rows rather than using the filter, you need to use

=SUBTOTAL(103,[@Column11])

and

=COUNTIFS(Table_1[Column11],">9",Table_1[IsVisible],1)

 

[DarkJester89]

As you are manually hiding rows rather than using the filter, you need to use

=SUBTOTAL(103,[@Column11])

and

=COUNTIFS(Table_1[Column11],">9",Table_1[IsVisible],1)

Thank you!! I added brackets around the quoted >9 but it works! Goodness gracious, thank you!

=COUNTIFS(Table1[Column11],{">9"},Table1[IsVisible],1)

 

[Fluff]

You do not need the {} in there.