Combining Totals (Office 2000-2003)

[sobershe]

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?

TIA

[HansV]

If you want to want to list the Fridays, it's easiest to just create a series of dates in column A in the summary sheet, and to use VLOOKUP or MATCH/INDEX to retrieve the values from the SME and NATL CITY sheets. See the attached version.

[sobershe]

I guess this falls under the "can't see the forest for the trees" category. I was looking for complex when the answer was simple - so simple!!

Thanks much Hans!