Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple countif()s or a better way? | Excel Worksheet Functions | |||
Multiple countifs | Excel Worksheet Functions | |||
COUNTIFs with multiple criteria | Excel Discussion (Misc queries) |