Thread: Sum data if dates in a column are w/in a specific range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Sum data if dates in a column are w/in a specific range
For example:

=SUMPRODUCT(--(A1:A100DATEVALUE("7/1/2009")),--(A1:A100<DATEVALUE("7/23/2009")),(H1:H100))

--
Gary''s Student - gsnu200860


"Dhardy" wrote:

I am trying to have Excel sum data in column M if data in column A is a
certain date range. Any tips/advice?
Reply With QuoteReply With Quote