Hi there,
I've attached the spreadsheet I'm working on. I need to ultimately show the total percentage of time being spent per line of business. This will change often, so I need a formula to grab the percentage by line of business each time it's changed.
Based on the "Coordinators - Active" tab, I need to show the following:
IF column B (Line of business) = Insurance (for example), what is the total added percentage taken from column D (% of time spent).
I want to put that in column C on the SUMMARY tab, under the appropriate line of business.
Thanks for much for your help! I'm not too familiar with nested ifs and and functions.
Anna
Bookmarks