Help with SUMIFS formula

Micah Turner
Micah Turner ✭✭✭✭
edited 05/23/22 in Formulas and Functions

Hello Experts! I am hoping someone can assist me here. I have a SUMIFS formula in the table shown below. It is in the "Expense Costs" column. It is pulling the information from another table in my Expense Tracker. It pulls only the expenses for a specific Job #. This formula works fine. However, and this is where I need your help, I need it to collect only the amounts from that table that are in a given month. I have tried to wrap in the MONTH formula, but cannot seem to get it to work. I know I am doing something wrong. Can someone assist please? Thank you in advance.


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!