How to Count Rows with defined values in multiple columns
Right idea but it gave me a "#NUM!" error. I think this formula must only be
for numbers. I need to count the number of times a string of text is entered
- when it's on the same row as a specific number.
"Bruno Campanini" wrote:
"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
|