Hello
I'm trying to do a sumifs formula based on 2 criterias. The first is a name.
the second one I can't do is when the date DAY is lower than 15.
For example in the table below I want to get the sum of A only lower than 15, the result should be 2.000
I was trying something (hardcoded just for clarity) like: +sumifs(value, name, "A", day(date),"<15")
But it doesn't go through, also thought to put them between {} but it doesn't work.
I don't want to do a 4th column with the days, but if its not possible I guess I can do that.
<tbody>
</tbody>
Thanks for the help
I'm trying to do a sumifs formula based on 2 criterias. The first is a name.
the second one I can't do is when the date DAY is lower than 15.
For example in the table below I want to get the sum of A only lower than 15, the result should be 2.000
I was trying something (hardcoded just for clarity) like: +sumifs(value, name, "A", day(date),"<15")
But it doesn't go through, also thought to put them between {} but it doesn't work.
I don't want to do a 4th column with the days, but if its not possible I guess I can do that.
Name | Date | Value |
A | 09/11/2019 | 1000 |
A | 09/13/2019 | 1000 |
A | 09/16/2019 | 1000 |
B | 09/14/2019 | 1000 |
B | 09/16/2019 | 1000 |
<tbody>
</tbody>
Thanks for the help