View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reggie Mitchell
 
Posts: n/a
Default Summing Rows with Multiple Criteria

Which function do I use to count all of the rows that have both the
numberical value 0 in column B AND the words "Star quality" in Column C?



A
B
C

Company
Widgets
Quality

Best Buy
5
Good

Computer City
0
Star Quality

WalMart
2
Star Quality

Sam's
1
Star Quality

Office Depot
3
Poor

Total Count

2