SUMIf Error

[somliving]

Hello Everyone.

I have a spreadsheet that looks similar to below

Name	Date	Number	1	2	3
Of Property	Acquired	of Units	352	352	525
River City	01/01/2017	252
Place Landing	03/06/2017	200
Village Green	01/01/2017	100

<tbody>
</tbody>

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

	A	B	C	D	E	F	G	H	I
1	Name	Date	Number	1	2	3	4	5	6
2	Of Property	Acquired	of Units	352	0	0	0	0	200
3	River City	1/1/2017	252
4	Place Landing	6/3/2017	200
5	Village Green	1/1/2017	100

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =SUMPRODUCT(--(MONTH($B$3:$B$5)=D$1),$C$3:$C$5) <tbody> </tbody>

<tbody>
</tbody>