Kim,
post the formula you are using. Indicate in what way it is not working:
Error values? Wrong values? Zero?

Are you trying to sum with more than one criteria?

Kostis Vezerides