Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 06, 02:55 PM posted to microsoft.public.excel.worksheet.functions
ajayb
 
Posts: n/a
Default 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   Report Post  
Old June 9th 06, 03:29 PM posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple countif()s or a better way? Mike Echo Excel Worksheet Functions 12 March 12th 06 02:43 PM
Multiple countifs ozcank Excel Worksheet Functions 2 November 14th 05 11:36 AM
COUNTIFs with multiple criteria Cene K Excel Discussion (Misc queries) 5 October 28th 05 10:43 PM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017