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 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies