I have attached a sample sheet where I need to combine the totals from the SME tab column L and the Natl City tab column K ONLY for the rows that are Fridays. What I would like is a formula that checks column B to see if the day is Friday and then adds column K and L as mentioned above. Ideally there would be a new tab for the combined totals that would list just the Friday dates and combined totals. Am I making sense? And is it possible to do an IF statement that checks for the value in one cell and adds the value in another cell? We will be doing a line-chart of the combined totals. Help?