Attachment 737567
I need a formula that can return the sum of all values based on the certain criteria. Currently, the workbook is done very manually, where I'd have to open the workbook and drag/update the sum formula.
Cell B9 is adding cells C2:G2 based on the grant date (Since we need future expense amount as of 12/31/2020, it's grabbing 3/31/2021-6/30/021) and cell C9 is adding D2:G2
Last edited by jeongs1; 06-23-2021 at 02:42 PM.
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Hello! I've updated and added an excel sheet with how the current process is being done.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks