| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting based on criteria from two cells???
I want to count in the following table the number of records where ColA0 and
ColB=R: ColA ColB 1000 R 1200 R 1300 R 0 R 11150 ADJ I tried using SUMPRODUCT(--(colA_NAME0),--(colB_NAME="R"). I defined ColA and ColB as named ranges. This does not seem to work and from researching on the net it seems that it should. Any suggestions?????? Thanks in advance, Attila |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting based on criteria from two cells???
Use SUMPRODUCT. You must specify a range.
=SUMPRODUCT(--(A1:A1000),--(B1:B100="R")) HTH, Paul -- "bevpike" wrote in message ... I want to count in the following table the number of records where ColA0 and ColB=R: ColA ColB 1000 R 1200 R 1300 R 0 R 11150 ADJ I tried using SUMPRODUCT(--(colA_NAME0),--(colB_NAME="R"). I defined ColA and ColB as named ranges. This does not seem to work and from researching on the net it seems that it should. Any suggestions?????? Thanks in advance, Attila |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting based on criteria from two cells???
If the named ranges refer to entire columns....SUMPRODUCT won't work.
You'd need to specify a range. Example: =SUMPRODUCT(A:A) returns an error but this one returns a correct value: =SUMPRODUCT(A1:A1000) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "bevpike" wrote in message ... I want to count in the following table the number of records where ColA0 and ColB=R: ColA ColB 1000 R 1200 R 1300 R 0 R 11150 ADJ I tried using SUMPRODUCT(--(colA_NAME0),--(colB_NAME="R"). I defined ColA and ColB as named ranges. This does not seem to work and from researching on the net it seems that it should. Any suggestions?????? Thanks in advance, Attila |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting based on criteria from two cells???
Thank you, this did help.
Attila "Ron Coderre" wrote: If the named ranges refer to entire columns....SUMPRODUCT won't work. You'd need to specify a range. Example: =SUMPRODUCT(A:A) returns an error but this one returns a correct value: =SUMPRODUCT(A1:A1000) Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "bevpike" wrote in message ... I want to count in the following table the number of records where ColA0 and ColB=R: ColA ColB 1000 R 1200 R 1300 R 0 R 11150 ADJ I tried using SUMPRODUCT(--(colA_NAME0),--(colB_NAME="R"). I defined ColA and ColB as named ranges. This does not seem to work and from researching on the net it seems that it should. Any suggestions?????? Thanks in advance, Attila |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Nonblank cells based on criteria in another cell | Excel Discussion (Misc queries) | |||
| Function - counting based on criteria | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
| counting based on criteria | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
