John C <johnc@stateofdenial wrote...
....
. . . It is why I automate processes that would otherwise require
copy/paste, or use macros to define the copy/paste. It is why I create macros
with my digital signature, and then I ensure my digital signature is in the
user's trusted sources.

And how many OPs do you suppose do this?

Maybe you could spend hours implementing data transfer and validation
procedures that would render it possible to use =SUMPRODUCT(--(MOD(x,
2)0)) to return the correct count of odd numbers. But unless there
were other reasons for it, I'd save the time and effort and use
=SUMPRODUCT(--(MOD(x,2)=1)) and get the same result.