Need help summing data from a specific Month

Options

Hi everyone,


I need assistance summing and counting data from a specific month. For the "Actual" column, I need two formula's in which it sums all the values up until the date I have under the "Date column", I also need it to start looking from the beginning of that exact month under the "Date" column too (Light Blue). I then need a similar formula in which it counts all those value for the same criteria as the light blue highlighted area, where it's from the beginning of that month up until the date in the "Date" column.


Regards

Rainier

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!