| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count # of Occurences
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of Occurences
Sweepea
How about =SUMPRODUCT(--($A$1:$A$3="Apple"),--($B$1:$B$3="Orange")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of Occurences
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of Occurences
Hi Nick,
It didn't count. It returned zero. Any thoughts? "Nick Hodge" wrote: Sweepea How about =SUMPRODUCT(--($A$1:$A$3="Apple"),--($B$1:$B$3="Orange")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of Occurences
Did you change the references to suit your actual ones?
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Sweepea" wrote in message ... Hi Nick, It didn't count. It returned zero. Any thoughts? "Nick Hodge" wrote: Sweepea How about =SUMPRODUCT(--($A$1:$A$3="Apple"),--($B$1:$B$3="Orange")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of Occurences
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. |
|
#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. |
| Reply |
| 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 | |||
Linear Mode
