Thanks for the feedback!

See this for more on SUMPRODUCT:

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Biff
Microsoft Excel MVP


"Bert Hyman" wrote in message
...
In "T. Valko"
wrote:

Try these:

1. In how many rows are either or both cells non-blank.

=SUMPRODUCT(--((A1:A10<"")+(B1:B10<"")0))

2. In how many rows does either or both cells have the value "A"

=SUMPRODUCT(--((A1:A10="A")+(B1:B10="A")0))


That seems to be the answer.

I'll admit that I'm still somewhat baffled by the SUMPRODUCT function,
but maybe now with some personally meaningful data, I can figure it out.

--
Bert Hyman St. Paul, MN