Count If Multiple Criteria is Met
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
|