Sumif? Or what to use
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 |
Quote:
|
All times are GMT +1. The time now is 07:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com