Thread: S.O.S.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default S.O.S.

Hi

If you have dates in column C then you would need to amend Kevin's
formula very slightly to

=sumproduct(--(month($c$2:$c$10) = 1), --($b$2:$b$10 = 1001),
($a$2:$a$10))


--
Regards

Roger Govier


"fuchka" wrote in message
ups.com...
it kinda didn't work :unsu