Forum Discussion
packie
Apr 10, 2024Brass Contributor
Find how many time a week no. is being used in another sheet
Hi,
Sheet1 Q5:Q1000 contains a value of 1 to 52 representing week numbers.
Sheet2 D5:D56 contain the values 1 to 52 which represents week numbers
I need a formula to be used in Sheet2 F5:F56 that will return the number of times a given week number can be found in Sheet1 Q5:Q1000
For example Sheet2 D18 contains the week no. 14
The formula then looks to find how many times 14 can be found in Sheet1 Q5:Q1000 and return the total number of times 14 is found.
The formula should find 6 instances where 14 can be found in Sheet1 Q5:Q1000
In this example the formula should return 6.
Thankyou for taking an interest.
Hi!
This can be achieved using the following formula:
=COUNTIF(Sheet1!$Q$5:$Q$1000,D5)You can enter this formula in E5 on Sheet2 and drag to E56.
Hope it works well!