Bracketing Issue

[ozbeachbum]

Need to get a result TRUE, current result is FLASE
=COUNTA(F3:H6,">0",+COUNTA(L3:P6,">0"))=COUNTA(F3:H6)-COUNTIF(F3:H6,0)*5
I have tried numerous different bracketing but have not been able to find one that will result in TRUE.

250119 bracket issue ca-cif.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2					Wed 01-Jan-25		Wed 01-Jan-25				Wed 01-Jan-25		TEST 01-03		NR
3					NR		NR				NR		NR		TEST02-02
4					Wed 01-Jan-25		Wed 01-Jan-25				Wed 01-Jan-25		TEST 01-03		NR
5					Sat 00-Jan-00		Sat 00-Jan-00				Sat 00-Jan-00		00		00
6					Sat 00-Jan-00		Sat 00-Jan-00				Sat 00-Jan-00		00		00
7
8	In my actual workbook all entries are the result of formulae from another worksheet
9	/=COUNTA(F3:H6,">0",+COUNTA(L3:P6,">0"))=COUNTA(F3:H6)-COUNTIF(F3:H6,0)*5												Result:		FALSE
10
11													/=COUNTA(F3:H6,">0",		04
12													+COUNTA(L3:P6,">0"))		06
13															10
14													=COUNTA(F3:H6)		04
15													-COUNTIF(F3:H6,0)		02
16															02
17													*5		10
18	Formula result Conditional Formatting in B2.												Required Result:		TRUE
19
20	I have tried numerous different bracketing but have not been able to find one that will result in TRUE.
Template

 

[Peter_SSs]

Can you explain in words, using your sample data, how you come up with these blue values?

 

[ozbeachbum]

I was using ELVAULATE FORMULA to try and work out the issue.

 

[Peter_SSs]

I was using ELVAULATE FORMULA to try and work out the issue.

That doesn't really answer my question. I assume the blue values are the intermediate values you want to produce to end up with the TRUE final answer?
If that is so, I want to know why you think the blue values should be those as I can't see why. I need to understand just what you are trying to do.

 

[ozbeachbum]

OK here goes,
If for example the number of entries in the five [5] columns equals the number of entries in column "F" * five [5] then the result would be TRUE and indicate that all entries are correct.
On the other hand if the number of entries in the five [5] columns don't equal the number of entries in column "F" * five [5] then the result would be FALSE and indicate that there is a missing entry.
Trust this is more like you requested.

 

[Peter_SSs]

Then based on your given layout & data , what about ..

25 01 19.xlsm
	F	G	H	I	J	K	L	M	N	O	P
2	Wed 01-Jan-25		Wed 01-Jan-25				Wed 01-Jan-25		TEST 01-03		NR
3	NR		NR				NR		NR		TEST02-02
4	Wed 01-Jan-25		Wed 01-Jan-25				Wed 01-Jan-25		TEST 01-03		NR
5	Sat 00-Jan-00		Sat 00-Jan-00				Sat 00-Jan-00		0		0
6	Sat 00-Jan-00		Sat 00-Jan-00				Sat 00-Jan-00		0		0
7
8
9									Result:		TRUE
ozbeachbum

Cell Formulas
Range	Formula
P9	P9	=COUNTA(F3:P6)=COUNTA(F3:F6)*5

 

[ozbeachbum]

Hi Peter,
Thanks for your time and patience.
I should have indicated in my last post that when I said entries, I was referring to entries >ZERO, so I trust that this information makes more sense.
The formula you give does result in true, the issue I have is because the worksheet entries are the result of formulae referencing another workbook.
If for example the result in N4 was ZERO instead of TEST 01-03 it would indicate that an entry was missing from the referencing workbook because there is an entry in "F4" >ZERO, but would still result in TRUE, which is why in my original formula I was only counting results >ZERO and minusing the ZEROS.
All entries showing in rows Five [5] & Six [6] aren't visible in the worksheet, I have shown them to show the results in those cells.

 

[Peter_SSs]

Then what about this?

=COUNTIF(F3:P6,"<>0")-COUNTBLANK(F3:P6)=COUNTIF(F3:F6,"<>0")*5

 

[ozbeachbum]

Thanks one again Peter, works fine.
Apologies if I was a bit vague in the beginning and for the delay in this reply, my computer pick up a virus and have had a lot of trouble getting back online.

 

[Peter_SSs]

No problem. Glad you are back up-and-running!