sumProduct (gimme a 1 if this is true, gimme the value) what is th
What you describe is what SUMIF does. The general format of that function is
=sumif(where_to_look,what_to_look_for,what_to_add) . In your example,
=sumif(DATA!$C$2:$C$1500,98366,DATA!$AB$2:$AB$1500 ). If, by chance, your zip
codes have been entered as text, you'll have to look for them as text, so
you'd change 98366 to "98366"
"Scott" wrote:
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
|