View Single Post
  #8   Report Post  
Myrna Larson
 
Posts: n/a
Default

Hi, Frank:

Maybe the problems is with missing parentheses:

=SUMPRODUCT(--(MONTH(A1:A100)=10),--(YEAR(A1:A100)=2004),B1:B100)

On Fri, 29 Oct 2004 18:16:05 +0200, "Frank Kabel"
wrote:

Hi
try
=SUMPRODUCT(--(MONTH(A1:A100=10),--(YEAR(A1:A100=2004),B1:B100)