Anyone know a better way?

Especially since COUNTIF doesn't seem to work in VBA?



"Atreides" wrote:

I'd really like Excel to have an All(range, criteria) function, as used in a
number of programming languages. For instance:

A B C D
1 y y y n
2


=ALL(A1:C1, "y") -- TRUE
=ALL(A1:D1, "y") -- FALSE

Though I suppose you can use this work-around code in the meantime:

=COUNTIF(A1:D1, "y")=COUNTA(A1:D1)

- which ignores blank cells in the calculation. Otherwise you can use:

=COUNTIF(A1:D1, "y")=MAX(COLUMNS(A1:D1),ROWS(A1:D1))

Anyone know a better way?