Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2008
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need formula help with Excel 2007

    I need the correct formula to update the AW column with column AV total when the status has a value of "approved" in column (N) and Column (O) has a value of March. The second condition that needs to be placed in the formula will update AW with the total of Sheduled March (AI) if no totals exist in column AV and column N has a value other than Approved but not blank. I also would like the counts in AW to be updated whenever modifications are made to AI or AV.
    Attached Files Attached Files

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

    Re: Need formula help with Excel 2007

    Could you provide some concrete, specific examples of what you want? I'm afraid I don't understand your description.

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

    Re: Need formula help with Excel 2007

    This appears to be the same question as <post:=699,914>post 699,914</post:>. Please post all replies there.

Posting Permissions

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