sum if and a range of cells
 

Need to build a formula that will total up cells - if the information for the
current year is entered, see example. This spreadsheet has totals for 2006
and we like to compare the totals for 2006 with the totals for 2007.
JAN Feb March ......... Total

2006 20 8 18

2007 15 10 25



In the total column for 2006 I would only like to add up Jan and Feb because
currently there is not a total for March 2007 - when there is I would like to
formula to automatically adjust seeing that there is now a total in the March
2007 cell.

Is this possible?

sum if and a range of cells
 

See your response under excel.misc.

"Erika" wrote in message
...
Need to build a formula that will total up cells - if the information for
the
current year is entered, see example. This spreadsheet has totals for
2006
and we like to compare the totals for 2006 with the totals for 2007.
JAN Feb March ......... Total

2006 20 8 18

2007 15 10 25



In the total column for 2006 I would only like to add up Jan and Feb
because
currently there is not a total for March 2007 - when there is I would like
to
formula to automatically adjust seeing that there is now a total in the
March
2007 cell.

Is this possible?

sum if and a range of cells
 

Yes it is. Let's assume the following

Jan -Dec 2006 in B2:M2
Jan - Dec 2007 in B3:M3

N2: =SUM(OFFSET(A2,0,1,1,COUNTA(B$3:M$3)))
N3: =SUM(OFFSET(A3,0,1,1,COUNTA(B$3:M$3)))

HTH,
Barb Reinhardt
"Erika" wrote:

Need to build a formula that will total up cells - if the information for the
current year is entered, see example. This spreadsheet has totals for 2006
and we like to compare the totals for 2006 with the totals for 2007.
JAN Feb March ......... Total

2006 20 8 18

2007 15 10 25



In the total column for 2006 I would only like to add up Jan and Feb because
currently there is not a total for March 2007 - when there is I would like to
formula to automatically adjust seeing that there is now a total in the March
2007 cell.

Is this possible?