COUNTIFS - cross referencing a sheet

aneekahTAL

Hello

I have a metrics sheet (Main Rollup) that I use to record a tally of task types as they complete. The actual tasks are tracked in a sheet called TPP Rollout - Hubs.

I am trying to count all the tasks where:

Task Category = "A" and State = "Complete" and FY = "FY25"

I am expecting a value of 26 , instead I get 0 with this formula

=COUNTIFS({TPP Rollout - Hubs Range 3}; {TPP Rollout - Hubs Range 2} = "A"; {TPP Rollout - Hubs Range 3}; {State 9} = "Complete"; {TPP Rollout - Hubs Range 3}; {TPP Rollout - Hubs Range 1} = "FY25")

Kelly Moore

Hey @aneekahTAL

The syntax for your COUNTIFS is not correct. COUNTIFS have the syntax of =COUNTIFS({Range 1}, criteria 1, {Range 2}, criteria, {Range 3 etc}, criteria 3}. A COUNTIFS can also be used with only one Range-criteria pair.

=COUNTIFS({TPP Rollout - Hubs Range 2}; "A"; {State 9}; "Complete"; {TPP Rollout - Hubs Range 1}; "FY25")

Does this work for you?
Kelly

Kelly Moore

Hey @aneekahTAL

The syntax for your COUNTIFS is not correct. COUNTIFS have the syntax of =COUNTIFS({Range 1}, criteria 1, {Range 2}, criteria, {Range 3 etc}, criteria 3}. A COUNTIFS can also be used with only one Range-criteria pair.

=COUNTIFS({TPP Rollout - Hubs Range 2}; "A"; {State 9}; "Complete"; {TPP Rollout - Hubs Range 1}; "FY25")

Does this work for you?
Kelly

aneekahTAL

Worked perfectly! Thankyou