If it is summing, you need to add a range to sum, like so

=SUMPRODUCT(--($A$1:$A$10="a"),--($B$1:$B$10="Alabama"),$C$1:$C$10)

change the ranges to suit

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SteveG" wrote in
message ...

Brian,

You should be able to use SUMPRODUCT.

=SUMPRODUCT(--(A1:A10="a"),--(B1:B10="Alabama"))

You can also put your state names in another cell and refer to that
cell rather than typing in the state's name in the formula above.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513151