How can I count per year and per week the total number of times a code occurs

		Microsoft Office Forums > Microsoft Excel > Excel
How can I count per year and per week the total number of times a code occurs

FAQ

Thread Tools

Display Modes

06-25-2020, 11:32 AM

Stefan_Deckers Stefan_Deckers is offline

Windows 10 How can I count per year and per week the total number of times a code occurs

Office 2010

Novice

Join Date: Jun 2020

Posts: 2

Stefan_Deckers is on a distinguished road

How can I count per year and per week the total number of times a code occurs

Dear,

How can I count per year and per week the total number of times a code occurs => only using column “Date” and column “Code”; so without extra “helper”- columns “Weeknumber” & “Year”.
My idea is to use only a formula, so without using pivot table, etc.

Thank you in advance,

Stefan

Attached Files

Number of times code occurs per week in 2020.xlsx (245.1 KB, 14 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you count how often a specific value occurs in single changing cell?	blackjack	Excel	12	09-03-2014 10:41 AM
Adding of times total to be in hours	jen0dorf	Excel	4	06-20-2014 11:53 PM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM
count how many tims a certain value occurs	lucnijs	Excel	6	03-26-2012 09:29 AM
How to count year lapse (rounded off) based on specific date	KIM SOLIS	Excel	1	11-01-2011 10:50 AM