Thread: sumProduct (gimme a 1 if this is true, gimme the value) what is th
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott
 
Posts: n/a
Default sumProduct (gimme a 1 if this is true, gimme the value) what is th
SUMPRODUCT(--(DATA!$C$2:$C$1500=98366), DATA!$AB$2:$AB$1500)

This is what I have been trying to use. What I am doing is looking for a
specific zip code in one column when I find it I want the value of another
column to be added to a total.

Scott Miller
University of Washington
Chemistry
Reply With QuoteReply With Quote