ExcelBanter - Countifs and multiple columns...

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

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

- - Countifs and multiple columns... (https://www.excelbanter.com/excel-worksheet-functions/93143-countifs-multiple-columns.html)

ajayb

Countifs and multiple columns...

Hi,

I have 2 columns of data. The first has a list of names, the second a list
of scores.

Fred 6
Fred 5
Joanne 5
David 4
Joanne 6

I want to use COUNTIF along these lines:

=COUNTIF(A1:A500,"Fred" and B1:B500,6)

But know it doesn't work. I have seen SUMPRODUCT bandied about but not
really sure if that'll help. Any ideas?

Thanks

Marcelo

Countifs and multiple columns...

Hi Ajayb,

try to use

=sumproduct(--(a2:a6="Fred")*(b2:b6=6))

does this helps?
regards from Brazil
Marcelo

"ajayb" escreveu:

Hi,

I have 2 columns of data. The first has a list of names, the second a list
of scores.

Fred 6
Fred 5
Joanne 5
David 4
Joanne 6

I want to use COUNTIF along these lines:

=COUNTIF(A1:A500,"Fred" and B1:B500,6)

But know it doesn't work. I have seen SUMPRODUCT bandied about but not
really sure if that'll help. Any ideas?

Thanks

All times are GMT +1. The time now is 02:34 AM.