Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rodeo rodeo is offline
external usenet poster
 
Posts: 2
Default 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.