P
Peter Atherton
JK
Try this =SUMIF($B$11:B15,TEXT(B16,1),$D$11
15)
Where B11:B15 is the list of companies for the last year
B16 is the company name for this year
and D1115 is the last years value
Regards
Peter
available. Is there an expression that means a formula
will automatically use the final 3 figures from all the
years i.e. detect whether the 2004 values have been input
yet, and if not, use the figures from 2003 back instead?
Try this =SUMIF($B$11:B15,TEXT(B16,1),$D$11
15)Where B11:B15 is the list of companies for the last year
B16 is the company name for this year
and D11
15 is the last years valueRegards
Peter
1998-2004. However, some values for 2004 are not yet
available. Is there an expression that means a formula
will automatically use the final 3 figures from all the
years i.e. detect whether the 2004 values have been input
yet, and if not, use the figures from 2003 back instead?