Countif for Filtered List Hello, May I please ask for some help. I am using the

Question

Countif for Filtered List

Hello,

May I please ask for some help. I am using the countif formula on a list, but would like to be able to filter i.e. by gender (column A) and other filters on my spreadsheet. Is there another formula I can use instead of the countif which will update the figures when filtered? Any suggestions appreciated!

Gender

C D G K L

Gender

Surname, Forename Both A*-C GCSE inc. Equivs. A*-G GCSEs inc. Equivs. F Student 1 2 0 3.5 M Student 2 0 0 0 M Student 3 2 1 3.5 F Student 4 2 4.5 8 =IF(COUNTIF(G3:G59,"2"),COUNTIF(K3:K59,">4.5"),0)

Explanation / Answer

...For COUNTIF on a filtered list -_=

I will take the example of =COUNTIF(F3:F6,">0.5") and remaining ones, you can do on your own following the same logic -

=SUMPRODUCT(SUBTOTAL(3,OFFSET(F3,ROW(F3:F6)-ROW(F3),))*(F3:F6>0.5))

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---