Good afternoon!
I am trying to write a sumifs function that will add up the "Total Gross Income" with the corresponding year and week number
Example
Week Number = 21 && Year = 2021 --> $602.85 ($68.75 $117.60 $285.00 $131.50)
Week Number = 21 && Year = 2022 --> $47.42 ($7.75 $6.25 $17.06 $16.30)
I tried to run this function:
=arrayformula(if(C2="","",sumifs($D$2:$D$9,$C$2:$C$9,C2:C)))
But, it will only return the total sum for the year 2021