Bob Phillips wrote:
Julie,

He might mean

=SUMPRODUCT(--(A1:A6="Blue"),--(B1:B6=F1:F6),C1:C6)

Jeff,

If so, you can also do it with

=IF(A1:A6="Blue",SUMIF(B1:B6,F1:F6,C1:C6))

which is basically what you said, and is an array formula, so commit with
Ctrl-Shift-Enter.


I don't think these two formulas,

=SUMPRODUCT(--(A1:A6="Blue"),--(B1:B6=F1:F6),C1:C6)

and

{=IF(A1:A6="Blue",SUMIF(B1:B6,F1:F6,C1:C6))},

express equivalent computations. Try them on:

A1:C6 houses:

{"blue","a",5;"blue","a",4;"red","b",3;"blue","a", 2;"blue","a",1;"red","b",2}

F1:F6 houses:

{"a";"b";"c";"d";"e";"f"}