Hello...

Could someone please tell me the easiest way to basically do the
following?

"If Cell A1 and Cell B1 both contain something, then count... If both,
or one of the Cells is blank, then ignore."

So basically...
A1 B1
x x
x
x
------------

I would like my formula cell to return a value of 1...

Thanks for any help!!!!

Stacy

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

--
Regards,
Tom Ogilvy

"stacy" wrote in message
oups.com...
Hello...

Could someone please tell me the easiest way to basically do the
following?

"If Cell A1 and Cell B1 both contain something, then count... If both,
or one of the Cells is blank, then ignore."

So basically...
A1 B1
x x
x
x
------------

I would like my formula cell to return a value of 1...

Thanks for any help!!!!

Stacy

=if(counta(a1:b1)=2,"both","not both")
or
=if(counta(a1:b1)=2,1,0)


stacy wrote:

Hello...

Could someone please tell me the easiest way to basically do the
following?

"If Cell A1 and Cell B1 both contain something, then count... If both,
or one of the Cells is blank, then ignore."

So basically...
A1 B1
x x
x
x
------------

I would like my formula cell to return a value of 1...

Thanks for any help!!!!

Stacy

--

Dave Peterson

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!!

Stacy,

Tom already gave you that:

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


--
steveB

Remove "AYN" from email to respond
"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!!

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!!

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

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

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