ExcelBanter - Count function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Count function? (https://www.excelbanter.com/excel-programming/410694-count-function.html)

If Col A contains a text variable and column B contains a numerical variable
associated with the text variable, what is the simplest formula I can put
into a single cell that will count the number of occurrences of the numerical
variables in Col B associated with the text variable in A?

For example:

dog 3
cat 2
bat 3
rat 1
hat 1
dog 1
cat 1
bat 2
rat 2
hat 2
dog 3
cat 3
bat 2
rat 3
hat 3

=SUMPRODUCT(--(A1:A15="dog"),--(B1:B15=3))
will return a 2
--
Gary''s Student - gsnu200785

"Zakynthos" wrote:

If Col A contains a text variable and column B contains a numerical variable
associated with the text variable, what is the simplest formula I can put
into a single cell that will count the number of occurrences of the numerical
variables in Col B associated with the text variable in A?