Forum Discussion

packie's avatar
packie
Brass Contributor
May 11, 2024
Solved

Add an additional condition where the value is greater than 0

Hi folks,    The following formula is used to return the number of times a week number is found in Sheet1 =COUNTIF(Sheet1!$R$5:$R$1000,D24)   Now I only want the number of times the week number ...
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    May 11, 2024

    packie 

     

    The COUNTIFS() function is suitable for this: So:

     

    =COUNTIFS(Sheet1!$R$5:$R$1000,D24,Sheet1!$O$5:$O$1000,">0")

     

     

dscheikey's avatar
dscheikey
Bronze Contributor
May 11, 2024

packie 

 

The COUNTIFS() function is suitable for this: So:

 

=COUNTIFS(Sheet1!$R$5:$R$1000,D24,Sheet1!$O$5:$O$1000,">0")

 

 

Resources