Home

Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-361198%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361198%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20data%20range%20(dates)%20in%20one%20worksheet%20that%20tracks%20the%20date%20of%20the%20event.%20I%20want%20to%20summarise%2C%20by%20month%2F%20Year%2C%20on%20a%20separate%20worksheet.%3C%2FP%3E%3CP%3EHowever%2C%20I%20quite%20fancy%20NOT%20using%20explicit%20ranges%20so%20I%20can%20change%20a%20cell%20to%20the%20correct%20year%20(e.g.%202019)%2C%20and%20it%20looks%20up%20the%20month%20and%20counts%20the%20number%20of%20events%20that%20occurred.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20welcome%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EAndrew%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-361198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363166%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363166%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20-%20I%20must%20have%20completely%20formula%20blinkered%20not%20to%20think%20about%20pivots!%20%3Ao%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-361207%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361207%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20may%20do%20that%20by%20Pivot%20Table%2C%20please%20see%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
AwesomeSauce
New Contributor

Hi,

I have a data range (dates) in one worksheet that tracks the date of the event. I want to summarise, by month/ Year, on a separate worksheet.

However, I quite fancy NOT using explicit ranges so I can change a cell to the correct year (e.g. 2019), and it looks up the month and counts the number of events that occurred.

 

Any thoughts welcome?

 

Best regards,

Andrew

2 Replies

You may do that by Pivot Table, please see attached

Thank you - I must have completely formula blinkered not to think about pivots! :o 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies