Summarize cost info by both contract and month

%3CLINGO-SUB%20id%3D%22lingo-sub-3493091%22%20slang%3D%22en-US%22%3ESummarize%20cost%20info%20by%20both%20contract%20and%20month%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3493091%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20a%20daily%20cost%20tracker%20spreadsheet%20which%20vertically%20lists%20various%20items%20in%20one%20column%20with%20a%20contract%20reference%20in%20another%20column%20(multiple%20items%20per%20contract).%20Then%2C%20there%20is%20a%20column%20for%20each%20day%20where%20daily%20costs%2C%20if%20any%2C%20are%20captured.%20I'm%20trying%20to%20find%20a%20way%20to%20summarize%20the%20data%20by%20both%20contract%20and%20month.%20A%20screen%20capture%20of%20part%20of%20the%20cost%20tracker%20shown%20below%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Caesarsra_0-1654871800013.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Caesarsra_0-1654871800013.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F379309i2628E695B060627C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Caesarsra_0-1654871800013.png%22%20alt%3D%22Caesarsra_0-1654871800013.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20advise%20how%2C%20using%20formulas%20and%2For%20pivot%20tables%20etc%2C%20I%20can%20generate%20a%20summary%20report%20by%20contract%20and%20by%20month%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3493091%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I've got a daily cost tracker spreadsheet which vertically lists various items in one column with a contract reference in another column (multiple items per contract). Then, there is a column for each day where daily costs, if any, are captured. I'm trying to find a way to summarize the data by both contract and month. A screen capture of part of the cost tracker shown below: 

 

 

Caesarsra_0-1654871800013.png

 

Can anyone advise how, using formulas and/or pivot tables etc, I can generate a summary report by contract and by month?

 

 

0 Replies