SUMIf Error

[somliving]

Hello Everyone.

I have a spreadsheet that looks similar to below

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Number[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Of Property[/TD]
[TD]Acquired[/TD]
[TD]of Units[/TD]
[TD]352[/TD]
[TD]352[/TD]
[TD]525[/TD]
[/TR]
[TR]
[TD]River City[/TD]
[TD]01/01/2017[/TD]
[TD]252[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Place Landing[/TD]
[TD]03/06/2017[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Village Green[/TD]
[TD]01/01/2017[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have a formula in D3-f3 to total the number of unit during that month and I am getting an error. Here is the formula:

=SUMIF(MONTH($B$3:$B$B51),"<="&D1,$C$3:$C$51)

Error=There's a problem with this formula. Not trying to type a formula

 

[TimNevins]

The first thing I see is that inside the Month statement you have two "B"s after the colon.

 

[Weazel]

Unfortunately you can not nest the month function inside the range of the sumif.

you would need to switch over to sumproduct....

just as a side note, i'm assuming your dates are English and not US

Unknown[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Number[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Of Property[/TD]
[TD]Acquired[/TD]
[TD]of Units[/TD]
[TD="align: right"]352[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]River City[/TD]
[TD="align: right"]1/1/2017[/TD]
[TD="align: right"]252[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Place Landing[/TD]
[TD="align: right"]6/3/2017[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Village Green[/TD]
[TD="align: right"]1/1/2017[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]D2[/TH]
[TD="align: left"]=SUMPRODUCT(--(MONTH($B$3:$B$5)=D$1),$C$3:$C$5)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]