Excel formula that does this...
 

Hi all,
I'm looking for a simple formula that will count the number of records that
meet these criteria. It doesn't matter if it's "countif", "sumif",
"sumproduct", etc... as long as it counts the number of records that meet the
criteria.
This is an example put in logical format:

=sumif((same_range,"one answer" OR same_range, "another answer") AND
(different_range, "required answer"))

Again, I'm looking for the count of (criteria OR criteria OR criteria) AND
(criteria)
Thanks for any help!


--
Cheers

something like
=sumproduct((rngA={"ans1","ans2"})*(rngB="ra"))

--
Don Guillett
SalesAid Software

"zubee" wrote in message
...
Hi all,
I'm looking for a simple formula that will count the number of records
that
meet these criteria. It doesn't matter if it's "countif", "sumif",
"sumproduct", etc... as long as it counts the number of records that meet
the
criteria.
This is an example put in logical format:

=sumif((same_range,"one answer" OR same_range, "another answer") AND
(different_range, "required answer"))

Again, I'm looking for the count of (criteria OR criteria OR criteria) AND
(criteria)
Thanks for any help!


--
Cheers

The equivalent of =sumif():

=sumproduct(--(a1:a10="one"),--(b1:b10="two"),c1:c10)
or
=SUMPRODUCT((A1:A10={"One","Not One"})*(B1:B10="two")*C1:C10)

For =Countif()

=sumproduct(--(a1:a10="one"),--(b1:b10="two"))
or
=SUMPRODUCT((A1:A10={"One","Not One"})*(B1:B10="two"))

zubee wrote:

Hi all,
I'm looking for a simple formula that will count the number of records that
meet these criteria. It doesn't matter if it's "countif", "sumif",
"sumproduct", etc... as long as it counts the number of records that meet the
criteria.
This is an example put in logical format:

=sumif((same_range,"one answer" OR same_range, "another answer") AND
(different_range, "required answer"))

Again, I'm looking for the count of (criteria OR criteria OR criteria) AND
(criteria)
Thanks for any help!

--
Cheers

--

Dave Peterson

This is exactly what i was looking for!!!
Thanks a bunch!
--
Cheers


"Don Guillett" wrote:

something like
=sumproduct((rngA={"ans1","ans2"})*(rngB="ra"))

--
Don Guillett
SalesAid Software

"zubee" wrote in message
...
Hi all,
I'm looking for a simple formula that will count the number of records
that
meet these criteria. It doesn't matter if it's "countif", "sumif",
"sumproduct", etc... as long as it counts the number of records that meet
the
criteria.
This is an example put in logical format:

=sumif((same_range,"one answer" OR same_range, "another answer") AND
(different_range, "required answer"))

Again, I'm looking for the count of (criteria OR criteria OR criteria) AND
(criteria)
Thanks for any help!


--
Cheers

glad to help

--
Don Guillett
SalesAid Software

"zubee" wrote in message
...
This is exactly what i was looking for!!!
Thanks a bunch!
--
Cheers


"Don Guillett" wrote:

something like
=sumproduct((rngA={"ans1","ans2"})*(rngB="ra"))

--
Don Guillett
SalesAid Software

"zubee" wrote in message
...
Hi all,
I'm looking for a simple formula that will count the number of records
that
meet these criteria. It doesn't matter if it's "countif", "sumif",
"sumproduct", etc... as long as it counts the number of records that
meet
the
criteria.
This is an example put in logical format:

=sumif((same_range,"one answer" OR same_range, "another answer") AND
(different_range, "required answer"))

Again, I'm looking for the count of (criteria OR criteria OR criteria)
AND
(criteria)
Thanks for any help!


--
Cheers