| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for certain months and summing the totals
Hi
I need a formula to first look for all of january date, febuary dates, etc. and total them under check amount column. Hope this is clear.thank you Amount Date Check Amount Month $320 1/29/2008 $1,886.24 Jan $40 1/29/2008 Feb $140 1/29/2008 Mar $80 1/29/2008 Apr $80 1/29/2008 May $1,200 1/29/2008 Jun $280 2/30/2008 Jul $1,200 2/31/2008 Aug $80 3/1/2008 Sep |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for certain months and summing the totals
=sumproduct((month(b2:b22)=1)*c2:c22)
to add the year =sumproduct((year(b2:b22)=2008)*(month(b2:b22)=1)* c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "sherobot" wrote in message ... Hi I need a formula to first look for all of january date, febuary dates, etc. and total them under check amount column. Hope this is clear.thank you Amount Date Check Amount Month $320 1/29/2008 $1,886.24 Jan $40 1/29/2008 Feb $140 1/29/2008 Mar $80 1/29/2008 Apr $80 1/29/2008 May $1,200 1/29/2008 Jun $280 2/30/2008 Jul $1,200 2/31/2008 Aug $80 3/1/2008 Sep |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for certain months and summing the totals
Ok Thank you. I think I understand the logic, but keep getting error #Value!
"Don Guillett" wrote: =sumproduct((month(b2:b22)=1)*c2:c22) to add the year =sumproduct((year(b2:b22)=2008)*(month(b2:b22)=1)* c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "sherobot" wrote in message ... Hi I need a formula to first look for all of january date, febuary dates, etc. and total them under check amount column. Hope this is clear.thank you Amount Date Check Amount Month $320 1/29/2008 $1,886.24 Jan $40 1/29/2008 Feb $140 1/29/2008 Mar $80 1/29/2008 Apr $80 1/29/2008 May $1,200 1/29/2008 Jun $280 2/30/2008 Jul $1,200 2/31/2008 Aug $80 3/1/2008 Sep |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for certain months and summing the totals
hmmm still getting the value error. not sure what I'm doing wrong.
so you are taking the =sumproduct((month(b2:b9)=1)*A2:A9) where column b has the date and column a has the amount right? Amount Date $320 1/29/2008 $40 1/29/2008 $140 1/29/2008 $80 1/29/2008 $80 1/29/2008 $1,200 1/29/2008 $280 2/30/2008 $1,200 2/31/2008 $80 3/1/2008 "Don Guillett" wrote: I used c as your values column when it should have been col A =sumproduct((month(b2:b22)=1)*c2:c22) =sumproduct((month(b2:b22)=1)*A2:A22) -- Don Guillett Microsoft MVP Excel SalesAid Software "sherobot" wrote in message ... Ok Thank you. I think I understand the logic, but keep getting error #Value! "Don Guillett" wrote: =sumproduct((month(b2:b22)=1)*c2:c22) to add the year =sumproduct((year(b2:b22)=2008)*(month(b2:b22)=1)* c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "sherobot" wrote in message ... Hi I need a formula to first look for all of january date, febuary dates, etc. and total them under check amount column. Hope this is clear.thank you Amount Date Check Amount Month $320 1/29/2008 $1,886.24 Jan $40 1/29/2008 Feb $140 1/29/2008 Mar $80 1/29/2008 Apr $80 1/29/2008 May $1,200 1/29/2008 Jun $280 2/30/2008 Jul $1,200 2/31/2008 Aug $80 3/1/2008 Sep |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Looking for certain months and summing the totals
Maybe your dollar amounts are text values and not proper numbers.
Pete On Jan 30, 4:22*pm, sherobot wrote: hmmm still getting the value error. not sure what I'm doing wrong. so you are taking the =sumproduct((month(b2:b9)=1)*A2:A9) where column b has the date and column a has the amount right? Amount *Date *$320 * 1/29/2008 *$40 * *1/29/2008 *$140 * 1/29/2008 *$80 * *1/29/2008 *$80 * *1/29/2008 *$1,200 * * * * 1/29/2008 *$280 * 2/30/2008 *$1,200 * * * * 2/31/2008 *$80 * *3/1/2008 "Don Guillett" wrote: I used c as your values column when it should have been col A =sumproduct((month(b2:b22)=1)*c2:c22) =sumproduct((month(b2:b22)=1)*A2:A22) -- Don Guillett Microsoft MVP Excel SalesAid Software "sherobot" wrote in message ... Ok Thank you. I think I understand the logic, but keep getting error #Value! "Don Guillett" wrote: =sumproduct((month(b2:b22)=1)*c2:c22) to add the year =sumproduct((year(b2:b22)=2008)*(month(b2:b22)=1)* c2:c22) -- Don Guillett Microsoft MVP Excel SalesAid Software "sherobot" wrote in message ... Hi I need a formula to first look for all of january date, febuary dates, etc. and total them under check amount column. Hope this is clear.thank you Amount Date * Check Amount Month $320 1/29/2008 * *$1,886.24 Jan $40 1/29/2008 Feb $140 1/29/2008 Mar $80 1/29/2008 Apr $80 1/29/2008 May $1,200 1/29/2008 Jun $280 2/30/2008 Jul $1,200 2/31/2008 Aug $80 3/1/2008 Sep- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Large Time totals not summing. | Excel Worksheet Functions | |||
| Add Totals for Last 12 Months | Excel Discussion (Misc queries) | |||
| Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
| How can I subtotal my weekly totals by months? | Excel Worksheet Functions | |||
| Help with Summing Up Totals | Excel Discussion (Misc queries) | |||
Hybrid Mode
