Home

Sum by Year

%3CLINGO-SUB%20id%3D%22lingo-sub-733438%22%20slang%3D%22en-US%22%3ESum%20by%20Year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733438%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20trying%20to%20Sum%20by%20Yehuda%3C%2FP%3E%3CP%3EThe%20data%20that%20is%20referenced%20is%20on%20a%20different%20worksheet%20in%20the%20same%20workbook.%3C%2FP%3E%3CP%3EThe%20table%20looks%20like%20this%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EYear%3C%2FTD%3E%3CTD%3EIncome%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2017%3C%2FTD%3E%3CTD%3E%240.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2018%3C%2FTD%3E%3CTD%3E%240.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2019%3C%2FTD%3E%3CTD%3E%240.00%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EThe%20date%20is%20in%20column%20AA%20of%20Worksheet%20PC%20and%20the%20title%20of%20the%20column%20is%20%22Close%20Date%22%3C%2FSPAN%3EThe%20data%20is%20on%20a%20worksheet%20in%20same%20workbook%20called%20PC%3C%2FP%3E%3CP%3EAnd%20the%20data%20that%20would%20populate%20the%20yearly%20sum%20is%20in%20column%20AC%20of%20worksheet%20PC%26nbsp%3B%20and%20the%20title%20of%20the%20column%20is%20%22Profit%2FLoss%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-733438%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%3CLINGO-SUB%20id%3D%22lingo-sub-757366%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20by%20Year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-757366%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F240888%22%20target%3D%22_blank%22%3E%40Yehuda%20Ordower%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20noticed%20that%20there%20are%20no%20responses%20to%20your%20post.%20Did%20you%20solve%20your%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%2C%3CBR%20%2F%3EPReagan%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Yehuda Ordower
Occasional Contributor

Im trying to Sum by Yehuda

The data that is referenced is on a different worksheet in the same workbook.

The table looks like this:

YearIncome
2017$0.00
2018$0.00
2019$0.00


The date is in column AA of Worksheet PC and the title of the column is "Close Date"
The data is on a worksheet in same workbook called PC

And the data that would populate the yearly sum is in column AC of worksheet PC  and the title of the column is "Profit/Loss"

1 Reply

Hello @Yehuda Ordower,

 

I have noticed that there are no responses to your post. Did you solve your problem?

 

Sincerely,
PReagan