Hi,

I've been playing around with this for a while but just can't make it work.

Table
2007 16
2006 14
2006 14
2007 10
2006 12
2007 12


I want a function that will give the following output
2006 (manually input) <40 (sum of all in 2006)
2007 (manually input) <38 (sum of all in 2007)

The bit in the < is the only thing I need the formula for.

Obviously I could just manually sum them all together, but this is just an example table, the real one has many years and thousands of cells.

Hope somebody is both kind and smart enough to point me in the right direction.


Cheers,
Teddy

=SUMIF(A1:A7,2006,B1:B7) for 2006 given that years are in column A and the numbers are in column B