Countifs and multiple columns...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Ajayb,

try to use

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

does this helps?
regards from Brazil
Marcelo


"ajayb" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
using COUNTIF I want to count multiple values 2
WHETHER TO USE COUNTIF, SUMIF or SUMPRODUCT 4
Countifs with different restrictions 1
combine countif and sumproduct? 2
COUNTIF oddity 1
Count column b if column a equal cell value 7
counting distinct entries with a qualification 7

Back
Top