"ryesworld" wrote in message
...
I need a formula or function that will sum the number of occurences a
specific text string is entered into cells in column B. I only want to
count
the occurences when a number that is in column A (on the same row as the
text) is equal to a specific number. Sounds easy but it's very
frustrating.

=SUMPRODUCT(--(AA1:AA6=YourNumber),--(AB1:AB6="YourString"))

Ciao
Bruno