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
