SOLVED

# Find how many time a week no. is being used in another sheet

Brass 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.

best response confirmed by packie (Brass Contributor)
Solution

# Re: Find how many time a week no. is being used in another sheet

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!

1 best response

Accepted Solutions
best response confirmed by packie (Brass Contributor)
Solution

# Re: Find how many time a week no. is being used in another sheet

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!