Posted to microsoft.public.excel.worksheet.functions

JRJ

external usenet poster

Posts: 6

Evaluating mulitple criteria with COUNTIF

Can anyone help me with a formula to count the number of occurrences a color
appears for a particular location?
Sample Data:

Location Color
2242 ALMOND
2247 ALMOND
2247 WHITE
2247 WHITE
2247 BLACK
2242 BLACK
2242 WHITE
2242 ALMOND
2242 BLACK
2242 ALMOND

Example Result:

Location ALMOND WHITE BLACK
2242 3 1 2
2247 1 2 1

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
COUNTIF Function with mulitple criteria?	Corey	Excel Worksheet Functions	6	January 28th 07 02:02 PM
count unique with mulitple criteria	ellebelle	Excel Worksheet Functions	22	October 13th 06 11:26 PM
LookUp with Mulitple Criteria	TimR	Excel Discussion (Misc queries)	4	July 13th 06 12:22 AM
mulitple criteria	imjustme	Excel Discussion (Misc queries)	9	September 2nd 05 02:07 AM
returning a value based on mulitple criteria	Brad	Excel Worksheet Functions	6	December 31st 04 08:14 AM

All times are GMT +1. The time now is 10:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us