| 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 |
| 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) | |||
Threaded Mode
