| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query for data in an array
I have data that is arranged as below
Column Name Col1 Col2 Col3 a b s a c w b d s b c w a d w I want to count number of s in col3 where col1 = a and col2 = b I am trying to use array formula using countif and if functions, but i am getting value# Can some one tell me the right way to get the result thanx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Query for data in an array
{=SUM(IF((A6:A10="a")*(B6:B10="b")*(C6:C10="s"),1, 0))}
"anonymous" wrote in message ... I have data that is arranged as below Column Name Col1 Col2 Col3 a b s a c w b d s b c w a d w I want to count number of s in col3 where col1 = a and col2 = b I am trying to use array formula using countif and if functions, but i am getting value# Can some one tell me the right way to get the result thanx |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Query for data in an array
=sumproduct((a2:a22="a")*(b2:b22="B")*(c2:c22="S") )
Does NOT have to be array entered -- Don Guillett SalesAid Software "anonymous" wrote in message ... I have data that is arranged as below Column Name Col1 Col2 Col3 a b s a c w b d s b c w a d w I want to count number of s in col3 where col1 = a and col2 = b I am trying to use array formula using countif and if functions, but i am getting value# Can some one tell me the right way to get the result thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
| How to import web query as array? | Excel Discussion (Misc queries) | |||
| Array formulas won't recognize external data from Microsoft Query | Excel Discussion (Misc queries) | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Linear Mode
