Help! I have gone over it several times and can't seem to find the error.
This formula sums the value of Williams jobs that were completed in the 4th billing quarter (Contracts and Billing- Active Range 1 calculates the billing quarter based on the calendar date)
=SUMIFS({Contracts and Billing- Active Range 4}, {Contracts and
Billing- Active Range 3}, "William Clayton", {Contracts and Billing-
Active Range 1}, "4")
I want to sum his jobs based on the current month rather than the billing quarter. When I change the second criterion range to Contracts and Billing- Active Range 2 (which is my date column) and make my second criteria =MONTH(TODAY()) it returns a zero even when it should return a sum amount. I have confirmed that Contracts and Billing- Active Range 2 is formatted as a date column. I have not used the month(today() function before. Maybe this is where I am messing up? I pasted the formula that isn’t working below
=SUMIFS({Contracts and Billing- Active Range 4}, {Contracts and
Billing- Active Range 3}, "William Clayton", {Contracts and Billing-
Active Range 2}, =MONTH(TODAY()))
Any advice would be much appreciated! Thank you.