View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raza Raza is offline
external usenet poster
 
Posts: 26
Default Sumif for Date Range

Hello-

Column A dates and Column C is what I want to sum. If the dates are between
1-1-07 and 1-31-07 I want to sum Column C. But I want to set up the formula
so I can change the month that is being summed easily. Here is my attempt to
do a sumif with a range:

=sumif(A:A,"=39141"&"<=39173",C:C)

It doesn't work, any help? Thanks!