Data gathering help pleasee

dela

New member
Joined
Sep 21, 2016
Messages
1
Reaction score
0
Points
0
Hi,

Could you give me your help please, I have a file attached here.
I did not managed to gather data per year and quarter in an easy manner on "data" sheet.
Could you help me to do that in an easy way with a formula please ?

Many thanks in advance for your precious help
Best
 

Attachments

  • Copy of Technical Interview (At Home).xlsx
    118.2 KB · Views: 25
do you want to reference the other sheets in the workbook?
 
Columns G & H on the attached sheet show the accumulation by year and quarter. You can continue to post additional years' entries in columns D thru F and they will also accumulate to the proper year/quarter entries. When you accumulate entries below the formulae, just drag the formulae down farther to include those additions.

Also, if you desire, you can move the lookup table that determines which quarter the line item belongs to to another sheet, as long as you re-do the formula in column B to find it.
 

Attachments

  • Project Cost Spreadsheet.xlsx
    123.4 KB · Views: 3
My mind kept working on your Project Capitalization spreadsheet, and I came up with several enhancements that I incorporated into this new version. It consolidates the lookup year/quarter into one column instead of three, moves the lookup table over to the right side of the sheet, and divides the four quarters for each year with lines for better readability.

I hope you approve!
 

Attachments

  • Project Cost Spreadsheet.xlsx
    122.5 KB · Views: 9
Back
Top