Please wait, please me think how to present my question clearly later
!!

T. Valko;3600755 Wrote:
Can you rephrase this:
-
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.-

--
Biff
Microsoft Excel MVP


"hkgoodwill" wrote in message
...-

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 -




--
hkgoodwill