Need assistance with COUNTIF while using multiple data arrays
=COUNTIF((A2:C2):(A4:C4):(A6:C6),1)
"Skyscan" wrote:
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
|