Thread: Sum and multiply at the same time?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
  
Posts: 376
Default Sum and multiply at the same time?
Agreed, Bob.
Force of habit I guess!!

--
Regards
Roger Govier

Bob Phillips wrote:
There is no need for the * operator Roger, there are no conditions.

=SUMPRODUCT(A3:Z3,A5:Z5)

works just fine

Reply With QuoteReply With Quote