Forum Discussion

packie's avatar
packie
Brass Contributor
Apr 10, 2024
Solved

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:...
excel
Formulas and Functions
  • MAngosto's avatar
    MAngosto
    Apr 10, 2024

    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!

MAngosto's avatar
MAngosto
Iron Contributor
Apr 10, 2024

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!