Good Evening,
I know my title doesn't explain it adequately, but I honestly don't know how to tell it any better. I have two columns: PAID & UNPAID. If I put Y in PAID, I want my TOTAL PAID box to update to show total hours paid automatically.
EG:
Job 1: 1.31 (Hours) Y (Paid)
Job 2: 2.45 (Hours) Y (Paid)
Job 3: 5.59 (Hours) N (Unpaid)
Then in my section TOTAL:
Total Paid: 4.16
Total Unpaid: 5.59
But, instead of me typing 4.16, I need some way of the sheet scanning the PAID Columns and adding up anything with a Y to the Total Paid field & same for Total Unpaid.
I hope I have explained it right?
Please help?
Thank you,
Bookmarks