Thread: Summing not summing
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default Summing not summing


"Harlan Grove" wrote in message
...
"Bob Phillips" wrote...
Try this array formula

=SUM(--D2:D6)
...

Should have used

=SUMPRODUCT(--D2:D6)

No I shouldn't, array SUM works.


Reply With QuoteReply With Quote