| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match cells in Range 1 with cells in Range 2 | New Users to Excel | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Linear Mode
