# Sumifs lower than a given day

#### el_ja

##### Board Regular
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.

 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

Excel Workbook
CDEF
1NameDateValue
2A9/11/20191000
3A9/13/20191000
4A9/16/20191000
5B9/14/20191000
6B9/16/20191000

Perfect!
Thanks a lot!

#### DanteAmor

##### Well-known Member
Try

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Name</td><td >Date</td><td >Value</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >A</td><td style="text-align:right; ">11/09/2019</td><td style="text-align:right; ">1000</td><td style="text-align:right; ">2000</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >A</td><td style="text-align:right; ">13/09/2019</td><td style="text-align:right; ">1000</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >A</td><td style="text-align:right; ">16/09/2019</td><td style="text-align:right; ">1000</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >B</td><td style="text-align:right; ">14/09/2019</td><td style="text-align:right; ">1000</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >B</td><td style="text-align:right; ">16/09/2019</td><td style="text-align:right; ">1000</td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Array Formula</td></tr><tr><td >D2</td><td >{=SUM(IF(A2:A6="A",IF(DAY(B2:B6)<15,C2:C6)))}</td></tr></table></td></tr></table>

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

### Forum statistics

1,082,305
Messages
5,364,406
Members
400,801
Latest member
julievandermeulen

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...