SOLVED

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

Brass Contributor

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.

 

 

1 Reply
best response confirmed by packie (Brass Contributor)
Solution

@packie 

 

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

@packie 

 

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!

View solution in original post