Forum Discussion
Using Formula MONTH() in SUMIFS()
My simplified table looks like this - Date Category Amount 8/1/2023 Housing $100.00 8/1/2023 Groceries $200.00 9/1/2023 Groceries $100.00 9/1/2023 Utilites $200.00 I am...
SUMPRODUCT() ignores logical values. SUMPRODUCT(B2:B4, --(A2:A4="Groceries"))
And since you omitted the MONTH() criteria you can use SUMIF() again.
I am trying to do something similar, I want to look at sales per sales rep per month where on another tab I have a total revenue figure and a criteria of closed one next to it
A1 is the actual revenue
A2 is the target
A3-4 is the month range
I started with this but cannot build it out without errors =SUMIF(Opportunities!O:O, "Closed Won", Opportunities!N:N)
| JANUARY | FEBRUARY | MARCH | APRIL |
| £50,000 | £32,000 | £30,000 | £21,000 |
| £66,667 | £66,667 | £66,667 | £66,667 |
| 01/01/2024 | 01/02/2024 | 01/03/2024 | 01/04/2024 |
| 31/01/2024 | 29/02/2024 | 31/03/2024 | 30/04/2024 |