What is the problem with the array formula (see cells in column R, which
are highlighted coloured yellow) ?

{=IF(SUM(IF(ISERROR(LOOKUP(N(OFFSET($B2,,{0,2,4,6, 8,10,12,14})),IF($A2="ABC",A!$A$2:$G$140,B!$A$2:$G $210))),0,IF(LOOKUP(N(OFFSET($B2,,{0,2,4,6,8,10,12 ,14})),IF($A2="ABC",A!$A$2:$G$140,B!$A$2:$G$210))= "Y",1,0)),IF(ISERROR(LOOKUP(T(OFFSET($B2,,{0,2,4,6 ,8,10,12,14})),IF($A2="ABC",A!$A$2:$G$140,B!$A$2:$ G$210))),0,IF(LOOKUP(T(OFFSET($B2,,{0,2,4,6,8,10,1 2,14})),IF($A2="ABC",A!$A$2:$G$140,B!$A$2:$G$210)) ="Y",1,0)))
0,"Y",""}

What I want to achieve with this formula is to count how many items as
shown in respective cells in column B,D,F,H,J,L,N,P are bearing 'Y" in G
column in respective table in 'A' worksheet and 'B' worksheet.

Please help !!




--
hkgoodwill