Sunday, May 12, 2013

yogi_Multi-Conditional COUNTIF (with exclusion condition)


                                          Google Spreadsheet   Post  #1193
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 12, 2013
user werdlum (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/FXj2Pa0iIGg)
How to exclude a cell from a count based upon a value in another cell?
Column C contains various text in each cell.  Column R contains specific text in each cell.  Column S contains various COUNT results based upon data throughout the sheet.

Here's what I want to do in a specific cell in Column S:

Count all the instances of "1" in Column R except for any row that has "ABC" in Column C.

How can I do this in Google Sheets?

Thanks a million for your help.

Using Chrome OS
-------------------------------------------------------------------------------------------------------------------
let us have a look at the following