I am having issues with a spreadsheet I have created. I am using a SUMPRODUCT formula for several different columns to return a count of data meeting those criteria's specified. One formula in each cell is targeted for a cell that I want to see data on. For example I have Monday through Friday in a drop down box. As I select Monday all the formulas should update with that days data along with the other criteria for the formula. When making my selections this takes about 1 minute to recalculate. Can someone help me speed this up. I had a fried who did something similar to this and it worked fast however I am no longer in touch. Please help!