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     www.energyefficientbuild.com.    Apr 17, 2013
user John Ambrose :(http://productforums.google.com/forum/?zx=fdisqnjyvx1n#!category-topic/docs/spreadsheets/UoXHJ74mGnA)
COUNTIFS

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

=ARRAYFORMULA(COUNTIF(IF('Reports/Commissions/Dish'!$M:$M="Y"&"*";IF('Reports/Commissions/Dish'!$C:$C>=B3;'Reports/Commissions/Dish'!$C:$C)),<=B4))

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