| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count data in range A:A that is dependent upon criteria .
I would like to count items in range A:A (header Priority with data 1 through
5) that are dependent upon range B:B )header Status with data IN WRK, COMP, OPN). So how do I count the 1s in A:A that are "COMP" in B:B? |
|
#2
|
|||
|
|||
|
One way:
=SUMPRODUCT(--(A1:A1000=1),--(B1:B1000="COMP")) See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of "--". In article , "h2ocats" wrote: I would like to count items in range A:A (header Priority with data 1 through 5) that are dependent upon range B:B )header Status with data IN WRK, COMP, OPN). So how do I count the 1s in A:A that are "COMP" in B:B? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
