Forum Discussion
Frustrated Noob
I am trying to write a formula that will act on a sheet that has 3 columns, this is for an expense report. One column has the date, one has the category and one has the amount ($). The amount is to ...
You can use SUMIFS for this purpose:
=SUMIFS(Expenses!D2:D1000, Expenses!A2:A1000, ">"&DATE(2024, 3, 31), Expenses!A2:A1000, "<"&DATE(2024, 5, 1), Expenses!B2:B1000, "Web Advertising")
Adjust the ranges as needed.
Thank you. I was trying SUMIFS but I didn't have it quite right. I know see what I was missing.