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.

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.

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.

sumif
 

=sumproduct((month(b2:b22)=1)*a2:a4)
=sumproduct((month(b2:b22)=1)*a2:a22)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
=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.