using Sumproduct with multiple criteria

[jchambers00]

I have a spreadsheet with attribute values in two columns; "month" in column A and "state" in column B
I need a sumproduct function that will add the values contained in column C when i am calculating a particular month/state total.
I tried the following, i think im close, but it didnt work
=SUMPRODUCT(--($A$1:$A$5= "Jan"),($B$1:$B$5= "NY"),(C1:C5))

thanks

[MickeyGreen]

Sometimes a little trial and error does the trick. I've only ever needed the preceeding "--" when making it work with named ranges. I'm still not sure why.

For your example try this:

=SUMPRODUCT(($A$1:$A$5= "Jan")*($B$1:$B$5= "NY")*(C1:C5))

[jchambers00]

thanks for the help, that did the trick