Thread: Sum If ???
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Sum If ???

Put those dates in D1 and D2

=SUMIF(A:A,"="&D1,C:C)-SUMIF(A:A,"<="&D2,C:C)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"abuckeye" wrote in message
...
I want to sum column C if Column A is greater than or equal to 1/1/06 &

less
than 2/1/06.

Any sugguestions?