ExcelBanter - COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. (https://www.excelbanter.com/excel-worksheet-functions/11613-count-information-column-b-only-if-a1-matches-k1-count-ce.html)

witchcat98

COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE.

i'm trying to count the cell information that's in column b but only if
columns a and k equal each other.

JE McGimpsey

One way:

=SUMPRODUCT(--(A1:A1000=K1:K1000),B1:B1000)

For an explanation of the "--" see

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
"witchcat98" wrote:

i'm trying to count the cell information that's in column b but only if
columns a and k equal each other.

All times are GMT +1. The time now is 09:44 AM.