Thread: Counting on two separate values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leif Leif is offline
external usenet poster
  
Posts: 10
Default Counting on two separate values
Thanks Ken, that works. What is "--"?

"Ken Johnson" wrote:

=SUMPRODUCT(--(MONTH($C$6:$C$53)=MONTH($A$1)),--(YEAR($C$6:$C
$53)=YEAR($A$1)),--($Q$6:$Q$53<31))

Ken Johnson

Reply With QuoteReply With Quote