Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i count how many times x in column a = 1 or 2 in column b
In column A, I have the numbers 1 - 6 recurring many times. In column B, I
have different prices for 1-6 eg, $5, $6, $7 and there are multiple occurences where 1 =$5, $6 etc What function do I type into a cell in column C to count how many times 1 = $5, 1 = $6, 2 = $5, 2 = $6 etc. I have tried =countif(a1:a100=1,b1:b100=$5) no good. =if(and(a1:a100=1,b1:b100=$5) no good either. Seems so simple. Help Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
How do I count how many times a code appears in a column? | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I count how many times x appears in a column? | Excel Worksheet Functions |