Help with SUMIFS formula

Micah Turner

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.

Micah Turner

That seems to have worked! Thank you very much for your help and quick response.

Jeff Reisman

Say you want the expenses dated in May, Try this:

=SUMIFS({Expense Tracker Amount}, {Expense Tracker Job #}, [Job #]@row, {New range to your date column}, MONTH(@cell) = 5)

Micah Turner

That seems to have worked! Thank you very much for your help and quick response.