Sumproduct

[seanrigby]

Assuming this is a sumproduct function, but not sure. See attached. Trying to figure out the total value based off of one location (i.e. "illinois").


Thanks for your help.

[zbor]

tRY THIS:

=SUMPRODUCT(--($A$9:$A$100=B2);$C$9:$C$100;$D$9:$D$100)

(REPLACE ; WITH , IF NEEDED)

[seanrigby]

It seems to come back with a error.

Please see attached.

thanks for your help.

[zbor]

You putted :

=SUMPRODUCT(--($A$9:$A$100=B2);($C$9:$C$14:$D$9:$D$100))

needs to be ; or , depending on settings:

=SUMPRODUCT(--($A$9:$A$100=B2);$C$9:$C$14;$D$9:$D$100)

or

=SUMPRODUCT(--($A$9:$A$100=B2),$C$9:$C$14,$D$9:$D$100)

[zbor]

Uploaded example:

[seanrigby]

Thanks for your help!