ExcelBanter - View Single Post

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