Bracketing Issue COUNTA COUNTIF

[ozbeachbum]

Hi,
I have the following formula which returns FALSE and I require TRUE.
I have tried numerous combinations and this is the closest I have gotten.
=COUNTA(BG64:BG356)-COUNTIF(BG64:BG356,0)=COUNTA(BI64:BI356)-COUNTIF(BI64:BI356,0)+(COUNTA(BK64:BK356)-COUNTIF(BK64:BK356,0))/2
COUNTA(BG64:BG356)-COUNTIF(BG64:BG356,0) RETURNS 7
COUNTA(BI64:BI356)-COUNTIF(BI64:BI356,0) RETURNS 7
(COUNTA(BK64:BK356)-COUNTIF(BK64:BK356,0))/2 RETURNS (53-46)/2; (7)/2; 3.5
7=7+3.5 RESULT 7=10.5 FALSE
What I am trying to achieve is:
7=(7+7) giving 14/2 giving 7 RESULT 7=7 TRUE
Trust this makes sense,
Thanks in advance.

 

[Fluff]

Maybe

=COUNTA(BG64:BG356)-COUNTIF(BG64:BG356,0)=(COUNTA(BI64:BI356)-COUNTIF(BI64:BI356,0)+(COUNTA(BK64:BK356)-COUNTIF(BK64:BK356,0)))/2

 

[ozbeachbum]

Thanks Fluff works perfectly.
The Wallabies have had a good run other than Scotland.
I am Looking forward to the Lions Tour next year.

 

[Fluff]

You're welcome & thanks for the feedback.
You're definitely better now that Jones has gone.