I have a spreadsheet that lists each job we have on continuous rows. I highlight in yellow the rows that contain the jobs that we have not recieved payment for. Periodically, I print a copy of the spreadsheet and manually add the 'yellow' jobs together. Is there a formula that will add the yellow amounts, only? Maybe a 'sumif' function? Thanks.
Bookmarks