| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count
I am trying to count two colums if they both meet/match a curtain number.
Example if A1 = 2 and B1 = 12 then add one to the count. The array that I am trying to count is two colums, A2:A800 and B2:B8000 |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(A2:A800=2),--(B2:B800=12))
HTH Jason Atlanta, GA -----Original Message----- I am trying to count two colums if they both meet/match a curtain number. Example if A1 = 2 and B1 = 12 then add one to the count. The array that I am trying to count is two colums, A2:A800 and B2:B8000 . |
|
#3
|
|||
|
|||
|
To count the matches in COLUMNS A and B:
=SUMPRODUCT((A2:A800=2)*(B2:B800=12)) On Mon, 21 Feb 2005 13:07:06 -0800, d sweeney <d wrote: I am trying to count two colums if they both meet/match a curtain number. Example if A1 = 2 and B1 = 12 then add one to the count. The array that I am trying to count is two colums, A2:A800 and B2:B8000 |
| 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 | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
Linear Mode
