I have a table with the following fields, note construction year is a number.
SuburbName ConstructionYear Size
SuburbA 1980 100
SurburbA 1989 200
SuburbB 2000 300
SuburbB 2009 400
I would like to sum up the size for the Construction Year in a range. See the table below for the expected output.
Tried sumif but couldn't get it to work. The ranges for example are:
>=1980 AND <1990
>=1990 AND <2000
SuburbName ConstructionYear TotalSize
SuburbA >=1980 AND <1990 300
SuburbB >=1990 AND <2000 700