Thread: Sum (IF
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kathy Goldie Kathy Goldie is offline
external usenet poster
  
Posts: 8
Default Sum (IF
=SUMPRODUCT(('reference data'!$E$2:$E$125=1)*('reference
data'!$I$2:$I$125=1)*('reference data'!$A$2:$A$125))


this word - here is the formula I used
THANK YOU!



*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote