Posted to microsoft.public.excel.worksheet.functions
|
|
Count rows based on multiple criteria
dmg wrote:
I have a need to count the number of rows in an Excel spreadsheet based on
contents of multiple cells. The formula is on one worksheet and all data is
on a second worksheet.
IE: count all rows that have the word "Windows" in column B and the word
"Complete" in column G.
Have not been able to figure this out with common functions like count,
countif, dcount, etc.
Help appreciated.
Try this:
http://www.contextures.com/xlFunctio...tml#SumProduct
|