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     www.energyefficientbuild.com.    Apr 19, 2013
user John Ambrose :(http://productforums.google.com/forum/?zx=9oeplwo48obf#!category-topic/docs/spreadsheets/scP6mBI8zkw)
Subtract rows from the total when marked as completed.
https://docs.google.com/spreadsheet/ccc?key=0AiHYduXZDrS8dHpCVDBLODFRWUpDcVVCaVBqRHZZVUE&usp=sharing

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


No comments:

Post a Comment