Thread: Mulitple SUMPRODUCTS?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Mulitple SUMPRODUCTS?

={211,215,330}
--
Don Guillett
SalesAid Software

"RJMAT" wrote in message
...
Hello,
Please review the formula I have created below. Is there a way to have
mulitple criteria's? Is this example, I used =211. I like to use
multiple
#'s. I don't think that nesting is the answser. Please advise.

Rich

=SUMPRODUCT(--('K:\0506FISC\SSOP''s June 06\[3308 - Trial
Balance.xls]3308 -
Trial Balance 11-1-2006'!$C$2:$C$1500=A23),--('K:\0506FISC\SSOP''s June
06\[3308 - Trial Balance.xls]3308 - Trial Balance
11-1-2006'!$B$2:$B$1500=211),--('K:\0506FISC\SSOP''s June 06\[3308 - Trial
Balance.xls]3308 - Trial Balance 11-1-2006'!$D$2:$D$1500))


Reply With QuoteReply With Quote