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/
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