using sumifs in excel vba

The code below works fin but I want to loop the sum to get a total so I have changed it to

Subtot = [=SUMIFS(Data!E2:E126,Data!C2:C126,wsv.Cells(1,I))]

if I hover over the panel it shows me the correct info but always return's a zero as the result.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

   For I = 3 To 28 Step 1
            
            If wsv.Cells(1, I) = "" Then
                Exit For
                
                Else
            
                Subtot = [=SUMIFS(Data!E2:E126,Data!C2:C126,(C1))]
                
                tot = tot + Subtot
                
                
                
            End If

           
            Next I

Confused, please repair my sanity.