Project Help Step 2
In the second step of the project, I know I am supposed to use the SUMIFS function to find the total number of transfers in European countries for the 2021/2022 seasons. The syntax that I am using for the equation is =SUMIFS(Database!$H:$H;Database!$E:$E;"Europe";Database!$C:$C;"2021/2022"). Yet it is only returning the value of 0. I know that the value is supposed to be 10,744 with using filters. Why is it displaying a value of 0?
1 answers ( 0 marked as helpful)
Hi,
Please make sure that the criterion "2021/2022" or "Europe" is written in the exact same way in the sum range columns.
Best,
Ned
Please make sure that the criterion "2021/2022" or "Europe" is written in the exact same way in the sum range columns.
Best,
Ned