Thread: Total up values for one month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Total up values for one month
Hello,

=sumproduct(--(year(e2)=year($e$2:$e$999)),--(month(e2)=month($e$2:$e
$999)),$f$2:$f$999)

and copy down.

Regards,
Bernd

Reply With QuoteReply With Quote