Excel formula that does this...

[Guest]

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!

 

[Don Guillett]

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

 

[Dave Peterson]

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"))

 

[Guest]

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

 

[Don Guillett]

glad to help