Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a data array consisting of 6 rows of numbers. Each row has a number
in each of the first 3 columns. 8 4 3 4 1 9 2 6 4 9 5 7 3 4 8 9 1 7 My objective is to count the number of times that the number "1" occurs in the even rows (rows 2, 4 & 6). I was intending to use the COUNTIF function for the 3 targeted rows, however I am not aware of how to do this. I tried this approach... =COUNTIF(A2:C2, A4:C4, A6:C6, "1") ....however it created a syntax error. I realize that I could sum 3 separate COUNTIF function calls - one for each row, however I was trying to use a single COUNTIF function call. Please assist. Thanks in advance!! Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple data ranges for countif | Excel Worksheet Functions | |||
Sum multiple arrays of data according to criteria | Excel Worksheet Functions | |||
Sumproduct assistance - need multiple ANDs and ORs | Excel Worksheet Functions | |||
LOOKUP across multiple arrays | Excel Discussion (Misc queries) | |||
sum of multiple arrays? | Excel Worksheet Functions |