Results 1 to 2 of 2

SUMIF - correct function?

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2008
    Location
    Georgia
    MS-Off Ver
    2013
    Posts
    72

    SUMIF - correct function?

    OK here is what I am trying to accomplish:

    Total Active should equal the sum of the numbers whose status is equal to PD, PP, and AP minus any number for these statuses that are in these >2 Months category.

    Total Terminated should equal all other status types and include the numbers >2 Months for PD, PP, and AP statuses.

    Using SUMIF does not seem to allow me to do all these commands.

    Could someone please assist me? I can provide more data if needed.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1