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

[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]

Question re-posted in google sheets.

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

=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))

www.mrexcel.com

 

[Fluff]

@LookingToLearn
Do you just want this for Google Sheets?

 

[LookingToLearn]

@LookingToLearn
Do you just want this for Google Sheets?

Yes sorry i posted this in the wrong section. Any help though would be appreciated

 

[Fluff]

OK, I will close this thread.
In future, if you post to the wrong section please report the post & we will move it. Thanks