Count If Multiple Criteria is Met
 

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

Count If Multiple Criteria is Met
 

=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

Count If Multiple Criteria is Met
 

=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

Count If Multiple Criteria is Met
 

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

Count If Multiple Criteria is Met
 

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

Count If Multiple Criteria is Met
 

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

Count If Multiple Criteria is Met
 

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

Count If Multiple Criteria is Met
 

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

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