nyuk, nyuk, nyuk.

(or sounds to that effect.)

Tom Ogilvy wrote:

Naw, I thought the original question was always for a multiple row range.
So if I were Moe and you were Larry or Curly, some pain would be called for
at this point <g

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Lady, you must be psychic.

Moe.


Tom Ogilvy wrote:

Just as previously stated:

=SUMPRODUCT(--(A1:A500<""),--(B1:B500<""))

--
Regards,
Tom Ogilvy

"stacy" wrote in message
oups.com...
Okay, that works perfectly... Now what if I have a range to look at?
Like A1:A500, and B1:B500? In Cell C1 I would like one value, telling
me how many total rows, from 1 to 500, have something in both the A
and
B columns? Is this possible or would I have to replicate the numeric
value, like in your formula, and then go back and "count" all the 1's
for my total?

A1 B1 C1
x x 3
x
x x
x
x x
x

C1=3 being the number of "true" rows that have data in both columns...

Thanks again for any clarification... I appreciate it!!


--

Dave Peterson

--

Dave Peterson