Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if cells have multiple data
Hello, Is there a way to count cells that contain multiple data? For example, I want to count the cells that contain "5 days:001", "5 days:002", "5 days:003", etc. The cells contain more data than I've listed, however this is the data I need to pull. I've tried the COUNTIF function, and it seems to be working if I only include one or two criteria, but I have six criteria I need to count. Thanks! -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=503520 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if cells have multiple data
On Fri, 20 Jan 2006 15:30:16 -0600, telewats
wrote: Hello, Is there a way to count cells that contain multiple data? For example, I want to count the cells that contain "5 days:001", "5 days:002", "5 days:003", etc. The cells contain more data than I've listed, however this is the data I need to pull. I've tried the COUNTIF function, and it seems to be working if I only include one or two criteria, but I have six criteria I need to count. Thanks! =COUNTIF(rng,CRITERIA_1) + COUNTIF(rng,CRITERIA_2) + COUNTIF(... --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if cells have multiple data
what about =countif(B1:b10,A1)+countif(B1:B10,A2)+countif(B1: B10,A3)+
etc........ A1 ,A2,....A6 hold your six criteria -- Greetings from New Zealand Bill K "telewats" wrote in message ... Hello, Is there a way to count cells that contain multiple data? For example, I want to count the cells that contain "5 days:001", "5 days:002", "5 days:003", etc. The cells contain more data than I've listed, however this is the data I need to pull. I've tried the COUNTIF function, and it seems to be working if I only include one or two criteria, but I have six criteria I need to count. Thanks! -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=503520 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Blank cells and Charting multiple data points | Charts and Charting in Excel | |||
Reference multiple cells in if statement | Excel Worksheet Functions | |||
Entering same data into multiple cells | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |