Posted to microsoft.public.excel.worksheet.functions

ajayb

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:43 PM
Multiple countifs	ozcank	Excel Worksheet Functions	2	November 14th 05 10: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 07:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us