Hi All,

I am trying to put an analysis for a survey I conducted where different categories responded with Agree, Disagree etc.

I came across a few formulas where I can count these when a filter is on but the formula keeps returning "0".
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B100,ROW(B2:B100)-ROW(B2),0,1)),--(B2:B100="Agree"))

I am not sure what I am doing wrong. Please find attached the excel. So If a filter by (S and SW) in column A, I want to be able to count the number of Agree and Disagrees.

Any help with be appreciated.
Thanks
Sample.xlsx