SumIfs with a Date

VTwyford

Once again I am having trouble with the SumIfs function. I am trying to get a total of postage paid for a client for each month, currently trying to find December 2022. I have the Customer Name column, Date Mailed column, and Postage Office Charge column. I have tried so many different formulas. Currently I have this: =SUMIFS([Post Office Charge]:[Post Office Charge], ([Customer Name]:[Customer Name], JONES), AND([Date Mailed]:[Date Mailed], >=DATE(2022, 12, 1), [date mailed]:[date mailed], <=DATE(2022, 12, 31))

I keep getting an #unparsable. Not sure how to make this formula work. I appreciate any help you can give me!

Thank you!

DKazatsky

Hi @VTwyford ,

Your formula is just slightly off. Try this: =SUMIFS([Post Office Charge]:[Post Office Charge], [Customer Name]:[Customer Name], "Jones", [Date Mailed]:[Date Mailed], >=DATE(2022, 12, 1), [Date Mailed]:[Date Mailed], <=DATE(2022, 12, 31))

Best,

Dave

DKazatsky

Hi @VTwyford ,

Your formula is just slightly off. Try this: =SUMIFS([Post Office Charge]:[Post Office Charge], [Customer Name]:[Customer Name], "Jones", [Date Mailed]:[Date Mailed], >=DATE(2022, 12, 1), [Date Mailed]:[Date Mailed], <=DATE(2022, 12, 31))

Best,

Dave

VTwyford

That worked!!! Thank you so much!!