=SUMPRODUCT(--(G2:G100="apple"),--(K2:K100="pie"))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"sparham" wrote in message
...
I'm trying to determine the number of times that certain data appears in
two
columns, on the same row. For example:
Below are two columns. I want to know how many times that column G has
"apple" and column K has "pie". I'm only interested in knowing how many
rows
contain both "apple" and "pie".
Column G Column K
apple pie
apple cider
orange juice
banana pudding
apple pie
banana bread
kiwi pie
apple pie
orange juice
kiwi juice
kiwi pie
orange danish
apple cider
orange juice
apple pie
orange juice
kiwi juice

Using the correct function(s), I should be able to get the answer; 4. But
I
don't know what function(s) to use.