Posted to microsoft.public.excel.worksheet.functions
|
|
Need assistance with COUNTIF while using multiple data arrays
Nice one, Max
(Makes my mess look even messier! I don't know WHAT I was thinking.)
***********
Regards,
Ron
XL2003, WinXP
"Max" wrote:
Another way ..
Try in say, F2:
=SUMPRODUCT((A1:C6=E2)*(MOD(ROW(A1:A6),2)=0))
where E2 will house the desired number, eg: 1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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
|