Using SUMIF to provide value of orders from this week only

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??

Find more posts tagged with

Forms

Sales

Sheets

Finance

Formulas

Marketing

Support

Cell linking

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

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?

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

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.

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…