How do i include SUBTOTAL(103) in my formula below? Its for a filtered count. (GoogleSheets)

[LookingToLearn]

=SUMPRODUCT(N((E6:E300="N")+(F6:F300="N")+(G6:G300="N")+(H6:H300="N")+(I6:I300="N")+(J6:J300="N")+(K6:K300="N")+(L6:L300="N")>0))

 

[jasonb75]

This can be done in excel but looking at other similar questions it would appear that what you want is not possible in google sheets.

There was one suggestion of using =COUNTA(FILTER(range = criteria)) but it wasn't clear from the post if that would work with rows being filtered or if it was an alternative.
Another suggestion was to use additional column filters so that only data meeting all of the criteria in the formula would be visible, then subtotal the remaining rows.

 

[LookingToLearn]

This can be done in excel but looking at other similar questions it would appear that what you want is not possible in google sheets.

There was one suggestion of using =COUNTA(FILTER(range = criteria)) but it wasn't clear from the post if that would work with rows being filtered or if it was an alternative.
Another suggestion was to use additional column filters so that only data meeting all of the criteria in the formula would be visible, then subtotal the remaining rows.

ok thanks for looking into it