How can I count multiple conditions where the data is not in order?

Anyone can help me to solve this?

I have data as following:

Collumn A Cal B Cal C Cal D
A 1 2 1
B 2 2 1
A 3 2 1
C 3 1 3
B 2 3 2
A 1 2 3

I want to count how many times that A answered 1.
I tried to use countifs formular, but it does not work unless I make a plus on formulas.
I also trying to avoid using SORT.

There is also attached file.

Thanks,
Sarin

Hi Sarin and welcome to the forum.

You can use SUMPRODUCT function for this.

=SUMPRODUCT((A1:A6="A")*(B1:D6=1))

Hope to jelps you.

Not clear to me that you want to count like this: A 1 2 1 count 1; A 2 3 4 count 0?
If yes, use:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Confirm by Ctrl-Shift-Enter
returns 3.

Which one??