OK, this is probably something simple I'm overlooking. I'm trying to use SUMIFS to return the values of monthly sales by customer and salesperson. So check out cell F3 on the Bobby tab. It should return a value of $73,829.82. I don't know what causes it to blow up, except that the error is generated by criteria range #3, which is Customer1. Apr-12 Sales report problem.xlsm
Please take a look and see if you can help me.
Thanks,
Jim
Bookmarks