Friday, April 19, 2013

yogi_Compute Number Of Jobs Not Closed Between Specified Sets of dates

                                          Google Spreadsheet   Post  #1145
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 19, 2013
user John Ambrose :(!category-topic/docs/spreadsheets/scP6mBI8zkw)
Subtract rows from the total when marked as completed.

Above is the link to a sample of my spreadsheet. The spreadsheet counts how many accounts there are and totals them based on the dates and how old the accounts are. What I can't figure out is how to subtract the accounts from the totals once they are marked as completed, which is shown by a "Yes" in the completed column. So in this case each of the totals would be 1 less because of the four accounts with "Yes" in their row. Any help would be much appreciated!

John Ambrose
following is a solution to the problem