Sheets countifs

Using Google sheets

People are give an option to reply other in a form. I want to be able to count The number of these. So I am using Countifs

Countifs allow us to count something if it meets multiple criteria

The first field is where to look ie where is the range.
In this case it on the tab responses in the range B2:B
note you need the exclamation mark to reference the tab
responses!B2:B

Determining if a value is not equal
"<>" in quotation marks is the same as not equals

Checking against a cell use an ampersand
&A2 will check against the value in A2

Here is the whole thing below each condition is separated by a comma.


=COUNTIFS(responses!B2:B,"<>"&A2, responses!B2:B, "> ", responses!B2:B,"<>"&A3,responses!B2:B,"<>"&A5,responses!B2:B,"<>"&A6,responses!B2:B,"<>"&A7,responses!B2:B,"<>"&A8,responses!B2:B,"<>"&A9,responses!B2:B,"<>"&A10,responses!B2:B,"<>"&A11,responses!B2:B,"<>"&A12,responses!B2:B,"<>"&A14,responses!B2:B,"<>"&A4)))