| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add data in a column
Hi,
I have found some functions similar to what i need but nothing that hits the spot and would appreciate any help. I have data in a number of sheets which contains date references and data entries associated. All sheets are a standardisd layout. Col F Col G 2004 2.4 2005 2.5 2005 3.5 2004 12.6 2005 16.5 2004 21 2006 15 I would like to create a formula which adds up the data by year for each diferent year ie. 2004 2.4, 2004 12.6, 2004 21 2005 2.5, 2005 3.5, 2005 16.6 2006 15 Which i can then extract into another sheet I look froward to any response. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add data in a column
Try this
=SUMIF(F1:F20,2004,G1:G20) Mike "MarkW1307" wrote: Hi, I have found some functions similar to what i need but nothing that hits the spot and would appreciate any help. I have data in a number of sheets which contains date references and data entries associated. All sheets are a standardisd layout. Col F Col G 2004 2.4 2005 2.5 2005 3.5 2004 12.6 2005 16.5 2004 21 2006 15 I would like to create a formula which adds up the data by year for each diferent year ie. 2004 2.4, 2004 12.6, 2004 21 2005 2.5, 2005 3.5, 2005 16.6 2006 15 Which i can then extract into another sheet I look froward to any response. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add data in a column
Thanks Mike, this works great.
"Mike H" wrote: Try this =SUMIF(F1:F20,2004,G1:G20) Mike "MarkW1307" wrote: Hi, I have found some functions similar to what i need but nothing that hits the spot and would appreciate any help. I have data in a number of sheets which contains date references and data entries associated. All sheets are a standardisd layout. Col F Col G 2004 2.4 2005 2.5 2005 3.5 2004 12.6 2005 16.5 2004 21 2006 15 I would like to create a formula which adds up the data by year for each diferent year ie. 2004 2.4, 2004 12.6, 2004 21 2005 2.5, 2005 3.5, 2005 16.6 2006 15 Which i can then extract into another sheet I look froward to any response. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add data in a column
Your welcome
"MarkW1307" wrote: Thanks Mike, this works great. "Mike H" wrote: Try this =SUMIF(F1:F20,2004,G1:G20) Mike "MarkW1307" wrote: Hi, I have found some functions similar to what i need but nothing that hits the spot and would appreciate any help. I have data in a number of sheets which contains date references and data entries associated. All sheets are a standardisd layout. Col F Col G 2004 2.4 2005 2.5 2005 3.5 2004 12.6 2005 16.5 2004 21 2006 15 I would like to create a formula which adds up the data by year for each diferent year ie. 2004 2.4, 2004 12.6, 2004 21 2005 2.5, 2005 3.5, 2005 16.6 2006 15 Which i can then extract into another sheet I look froward to any response. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort data in column B to align with data in column A? | New Users to Excel | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
Linear Mode
