SUMPRODUCT(--(C2:C834="8000-0010"),--(C2:C834<="8000-0510"),J2:J834)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TimR" wrote in message
...

I am trying to sum if the criteria is between two values;

SUMIF(C2:C834,(=8000-0010,<=8000-0510),J2:J834)

I keep getting error messages. The data is formatted as the attached
(hopefully). In the example I point to the values 8000-0010 and 8000-
0510.

Any help would be appreciated.

Tim


--
TimR
------------------------------------------------------------------------
TimR's Profile:
http://www.excelforum.com/member.php...o&userid=27843
View this thread: http://www.excelforum.com/showthread...hreadid=478878