SUMIFS for a date range
I’m in sheet name “Summary” and trying to get total “Cost” from Sheet name “Expenses” where “Charge Date” in sheet “Expenses” between 10/1/2023 and 12/31/2023 
I’m getting Unparseable error. The formula I'm using is:
=SUMIFS({Expenses Range 1},[ Charge Date]:[ Charge Date], >=DATE(2023, 10, 1) ,[ Charge Date]:[ Charge Date], <=DATE(2023, 12, 31))
Best Answers

Hi
It looks like you are adding the formula to a sheet called Summary and all the data is in the Expenses sheet. You therefore need to set up crosssheet references for both columns in the Expenses sheet.
You have one for the amounts and you have called this {Expenses Range 1}
You need another for the Charge Date column.
To do this...
Edit your formula and highlight the column reference:
Click on Reference Another Sheet to replace this with a new column reference.
Find your Expenses sheet in the tree.
Highlight the Charge Date column.
Give it a name (or leave it as the Expenses Range 2 default).
The formula will update like this
Copy that reference (the one with the arrow) and paste it over the second column reference (highlighted in blue).
Your formula now looks like this

Fantastic  Worked perfectly. Thank you so much for the quick help
Answers

Hi
It looks like you are adding the formula to a sheet called Summary and all the data is in the Expenses sheet. You therefore need to set up crosssheet references for both columns in the Expenses sheet.
You have one for the amounts and you have called this {Expenses Range 1}
You need another for the Charge Date column.
To do this...
Edit your formula and highlight the column reference:
Click on Reference Another Sheet to replace this with a new column reference.
Find your Expenses sheet in the tree.
Highlight the Charge Date column.
Give it a name (or leave it as the Expenses Range 2 default).
The formula will update like this
Copy that reference (the one with the arrow) and paste it over the second column reference (highlighted in blue).
Your formula now looks like this

Fantastic  Worked perfectly. Thank you so much for the quick help

happy to help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!