| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum different rows
I have a speadsheet that contains the data of a date format and currency
format. For example: Col A Col B ROW 1 3/8/2005 $5.00 ROW 2 3/8/2006 $25.00 ROW 3 3/8/2007 $10.00 ROW 20 3/8/2005 $5.00 ROW 21 3/8/2006 $25.00 ROW 22 3/8/2007 $10.00 ROW 33 3/8/2005 $5.00 ROW 34 3/8/2006 $25.00 ROW 35 3/8/2007 $10.00 My questions is... How do i get the sum of Col B for the current year? For example if I use this year my formula should return $75.00. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sum different rows
=SUMPRODUCT(--(YEAR(A1:A35)=2006),B1:B35)
------------------ mama no teeth "btijoe" wrote: I have a speadsheet that contains the data of a date format and currency format. For example: Col A Col B ROW 1 3/8/2005 $5.00 ROW 2 3/8/2006 $25.00 ROW 3 3/8/2007 $10.00 ROW 20 3/8/2005 $5.00 ROW 21 3/8/2006 $25.00 ROW 22 3/8/2007 $10.00 ROW 33 3/8/2005 $5.00 ROW 34 3/8/2006 $25.00 ROW 35 3/8/2007 $10.00 My questions is... How do i get the sum of Col B for the current year? For example if I use this year my formula should return $75.00. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sum different rows
Thank You,
That worked fine. I changed it a little =SUMPRODUCT(--(YEAR(A1:A35)=YEAR(TODAY())),B1:B35) Thanks again "Nobody" wrote: =SUMPRODUCT(--(YEAR(A1:A35)=2006),B1:B35) ------------------ mama no teeth "btijoe" wrote: I have a speadsheet that contains the data of a date format and currency format. For example: Col A Col B ROW 1 3/8/2005 $5.00 ROW 2 3/8/2006 $25.00 ROW 3 3/8/2007 $10.00 ROW 20 3/8/2005 $5.00 ROW 21 3/8/2006 $25.00 ROW 22 3/8/2007 $10.00 ROW 33 3/8/2005 $5.00 ROW 34 3/8/2006 $25.00 ROW 35 3/8/2007 $10.00 My questions is... How do i get the sum of Col B for the current year? For example if I use this year my formula should return $75.00. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Linear Mode
