Forum Discussion

SG-2020's avatar
SG-2020
Copper Contributor
May 22, 2020
Solved

Tab number in COUNTIF calculation

Hi Need to collect data per week [each in a separate tab] and count how many occurances are there into a  summary tab using COUNTIF  Cell X = =COUNTIF(Week20!$D$5:$D$40,Week10!$D$1) How can I rep...
  • Jos_Woolley's avatar
    May 22, 2020

    SG-2020 

     

    Hi,

     

    =COUNTIF(INDIRECT("'"&Z2&"'!D5:D40"),Week10!$D$1)

     

    Regards