View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sumif a date time colum and information

"JMB" wrote:
That works fine, is there also a way that you could
do the same thing only monthly by year.


Sure, something like this:
=SUMPRODUCT((TEXT(A2:A10,"mmmyyyy")="Jan2009")*B2: B10)

Do take a moment to press the "Yes" button below to the question:
"Was this post helpful to you?" from where you're reading this.
It'll ensure a longer shelf life to this thread for the general benefit
of other readers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---