Home > database >  Calculate sum if year and weekdate match in the columns
Calculate sum if year and weekdate match in the columns

Time:06-07

enter image description here

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

Here is a link to a copy of the sheet: enter image description here

  • Related