Using SUMIF to provide value of orders from this week only

grant53396

Hi,

I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value.

=SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value})

The sheet references are to single columns titled 'Completion Date' and 'Order Value' respectively, but not sure what is not working as part of this?

Please could someone assist with this??

L_123

=SUMIF({Completion Date}, WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()), {Order Value})

 

grant53396

Thanks Luke; tried this, but got the invalid reference, as shown in the attached screen shot. Any thoughts as to what i'm doing wrong here?

 

L_123

Am I going crazy or do you  have 3 periods in your formula? 

L_123

Those aren't periods, but IDK what they are. Some sort of subscript. Try erasing the parethesis after today and retyping them.

 

Other than that you might have some data formatting issues in your references. Your formula is typed out correctly.