match and not count blank cells

[webmax]

Hi Team,
I have excel sheets In that I have data from column C to column 7.
If the Input data all matching then I get the output as True. (The Blank should not be counted)

If all the Cell Data is Revenue then output comes as True. Provided the blank should not be counted. In this 4,7 & 8 data is Revenue.

Attaching the excel sheet for reference

Thanks

 

[vletm]

webmax
How Your 6 data is True ... if there are none Revenue?
How Your 8 data is Revenue ... if there are nothing?
If all should be Revenue then something like this?

 

[p45cal]

in K4:

=SUM(1/COUNTIF($C4:$J4,$C4:$J4 & ""))-(COUNTBLANK($C4:$J4)>0)=1

or

=COUNTA(UNIQUE(C4:J4,TRUE))-(COUNTBLANK(C4:J4)>0)=1

Depending on your version of Excel, you may have to commit the formula to the cell with Ctrl+Shft+Enter rather than just the usual Enter.
Copy down.

 

[Excel Wizard]

Maybe try

=COUNTIFS(C4:J4,LOOKUP("z",C4:J4))=COUNTA(C4:J4)