How to Count Rows with defined values in multiple columns
Do you mean something like this:
=SUMPRODUCT((Sheet2!A1:A20=C1)*(Sheet1!B1:B20=D1))
?
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"ryesworld" wrote in message
...
YES, that works, unless the two ranges you are searching (A1:A20 & B1:B20)
are on a separate sheet... that produces a #NAME? error. Any ideas?
"RagDyer" wrote:
With the text to look up entered in D1,
And the specific number to use in C1, try this:
=SUMPRODUCT((A1:A20=C1)*(B1:B20=D1))
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"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.
|