# Thread: Combining Totals (Office 2000-2003)

1. ## Combining Totals (Office 2000-2003)

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

2. ## Re: Combining Totals (Office 2000-2003)

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.

3. ## Re: Combining Totals (Office 2000-2003)

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!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•