Hi

Try something like:
=SUMPRODUCT((A1:A50="apples")*(B1:B50="oranges"))
I don't quite understand the "If this occurs on multiple rows, I want to
count them all as one sum." bit, but it's a start at least!

Andy.

"force530" wrote in message
...
I have two columns with lets say a range of 50 (a1:a50) and (B1:B50). I
want
to count the number of occurences when a specific arguement occurs. i.e.,
If
A23=apples and b23=oranges, I want to count this occurence, but only if
this
occurs together on the same row. If this occurs on multiple rows, I want
to
count them all as one sum.