Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a 700 line spreadsheet, 2 columns). Column A has is a name (it is
concatenated from elsewhere) and column B is a value (A or B). I made a list of all the unique names from the first column and placed it in Column E. I would like to be able to look at the list of 700 and cound the number of "A"s and "B"s CarA A CarB B CarA B CarA A Here is what I tried: =COUNT(IF((A$2:$A$701=$S13)*($F$2:$F$701="A"),$F$2 :$F$701)) It doesn't work, I get 0's |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array: Counting multiple values within array | Excel Worksheet Functions | |||
ARRAY NOT COUNTING A CERTAIN ROW | Excel Worksheet Functions | |||
Searching/Counting an array | Excel Discussion (Misc queries) | |||
Counting with Array Formula | Excel Worksheet Functions | |||
Counting an Array based on a calculation | Excel Discussion (Misc queries) |