proper formula for countif (a1:b10, "apple && pie")

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

Could I get some assistance with a criteria for (i think, COUNTIF)?
Using the below as an example.

what would be formula be to say:

=number of rows that have "apple" and "pie" (2)

A B C

1 apple pie MaryJane
2 apple muffin Sue
3 apple pie BettyBoop
4 peach pie Lilly
5 peach muffin Cate

or is this to compliated? none of the examples that I've found have
this specifically.

thanks,
Alex
 
Assume your data is in the range A1:C5 then

=SUMPRODUCT((A1:A5="apple")*(B1:B5="pie"))

will do the trick

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
thanks for that...very ingenious
(I had to get the figure out what you were doing there :)
-alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF formula? 1
Excel CHALLENGE...3 questions(indirect,rank,array formula)... 7
Countif Function Using "AND" 3
COUNTIF not including something in both columns 2
Formula format for Count or Countif funtion with two criterias 2
Need formula for multiple conditions in 3 columns 2
Using sum(1/countif....) not returning expected result 10
Conditional Autofilter For Formula 4

Back
Top