Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif
Ok, I'm frustrated. I need to sum values in column "A" if values in column
"B" are during the month of "January" formated as a DATE (1/1/2008) I have tried variations of SUMIF ((B2:B4="=date(2008,1,1)")*(b2:b4)="<=date(2008,1 ,31))*a:2:a4) And can't get it to work. What I actually have is a column of expenses and another column with their associated dates. I want to know how much was spent each month without putting in a summing line at the end of each month. Does that make sense? Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif
=SUMPRODUCT((B2:B4=DATE(2008,1,1))*(B2:B4<=DATE(2 008,1,31))*(A2:A4))
-- David Biddulph "rodeo" wrote in message ... Ok, I'm frustrated. I need to sum values in column "A" if values in column "B" are during the month of "January" formated as a DATE (1/1/2008) I have tried variations of SUMIF ((B2:B4="=date(2008,1,1)")*(b2:b4)="<=date(2008,1 ,31))*a:2:a4) And can't get it to work. What I actually have is a column of expenses and another column with their associated dates. I want to know how much was spent each month without putting in a summing line at the end of each month. Does that make sense? Thanks for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif
=sumproduct((month(b2:b22)=1)*a2:a4)
-- Don Guillett Microsoft MVP Excel SalesAid Software "rodeo" wrote in message ... Ok, I'm frustrated. I need to sum values in column "A" if values in column "B" are during the month of "January" formated as a DATE (1/1/2008) I have tried variations of SUMIF ((B2:B4="=date(2008,1,1)")*(b2:b4)="<=date(2008,1 ,31))*a:2:a4) And can't get it to work. What I actually have is a column of expenses and another column with their associated dates. I want to know how much was spent each month without putting in a summing line at the end of each month. Does that make sense? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |