Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
    Attached Files Attached Files
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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.
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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!
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

Posting Permissions

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