Sum of Totals by area and Date
I am trying to set up a formula that does the following:
If in Work Log A, the Plant is X and the date range is between 1012020 and now, what is the total cost of this time range for this sheet?
I also want to break down by monthly range:
If in Work Log A the plant is X and the date range is between 112021 and 1312021, what is the total cost of this time range for this sheet?
I have similar formulas for the references in the other sheets, but what's hanging me up is trying to specify a date range within the formula.
Best Answer

No. The @cell is as it should be. It looks like you have a period after the first @cell reference though. Try removing that. You are also going to want GREATER THAN or equal to for your first date argument, but you only have equal to.
Answers

Try something along the lines of...
=SUMIFS({Source Sheet Column To Sum}, {Source Sheet Plant Column}, "Plant X", {Source Sheet Date Column}, AND(@cell >= DATE(2020, 10, 01), @cell <=TODAY()))
EDITED to correct a typo in the formula

I got an Unparseable error for the formula with that formula. Here is a screenshot of it:
Do i need to put a specific cell reference for @cell? if so, what should i do when i want the total of everything that meets the date and plant criteria?

No. The @cell is as it should be. It looks like you have a period after the first @cell reference though. Try removing that. You are also going to want GREATER THAN or equal to for your first date argument, but you only have equal to.

That solved it, i must not have hit shift on the period to get the greater than symbol. Thank you so much for the help!!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!