| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count # of Occurences
You're welcome. Thanks for the feedback!
Biff "Sweepea" wrote in message ... It works now. Thank you very much!! "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A10="apple"),--(B1:B10="orange")) Or ,use cells to hold the criteria: D1 = apple E1 = orange =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1)) Biff "Sweepea" wrote in message ... Question: A B Apple Orange Apple Pear Apple Orange I will like a formula to count the number of occurrences if column A=Apple AND column B=Orange. Please help. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Count occurences between dates | Excel Worksheet Functions | |||
Threaded Mode
