Thank you all so much -
Verizonrep - your formula worked perfectly and then I started applying it to underlying worksheets as well and they were all different lengths and changing the length was annoying on each sheet!
So I was about to post to see if there was a way to do it dynamically and...
Ok, I know I have done this before but for some reason I am having a terrible time with it now...Please help & thanks in advance.
I have this table:
Inititive |Cost |Approved? | Notes
PR Team |5,000 |X |
Print Plan |2,500 | |See Jamie
Web...
Basically it looks like this:
Inititive | Description | Budget | Approved
Approved would be the check box.
If I check approved I want the the budget amount added to my total line. If it is not checked I want it to show in the list but not in the total.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.