Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |