Wednesday, April 17, 2013

yogi_Count If Column M Houses Y or Yes And Column C Values Are Greater GT or = B3 And LT or = B4 In Sheet1

                                          Google Spreadsheet   Post  #1137
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 17, 2013
user John Ambrose :(!category-topic/docs/spreadsheets/UoXHJ74mGnA)

I need help with this formula or a suggestion for what will work:


The column 'Reports/Commissions/Dish'!$M:$M is manually updated by the office staff with a Y or Yes to show that an account has been closed out. I want the formula to count the accounts with a Y in their row so that I can subtract them from the total of accounts pending from the whole list.
following is a solution to the problem