Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    48

    Unanswered: Sum With If Condition

    I have a statement, in which, against four quarters, their target vs. achievement figures along with total target & achivement are appearing like as below

    Quarter-1 Quarter-2 Quarter-3 Quarter-4 Total
    Tgt. Ach Tgt. Ach Tgt. Ach Tgt. Ach Tgt. Ach

    15 10 12 0 22 0 18 14

    Now, I want to sum the computed target of all four quarters in Total column where corresponding achievement is greater than 0. Thus means, from the above example, I want to sum only target of Quarter-1 and Quarter-4 only.

    I have tried with the sum with if command, but it does not work if achievement is 0 and returns "FALSE".

    Any solution to the above is requested.

    Thanking you in advance

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, and welcome to the board.

    You need to use SUMPRODUCT which allows multiple conditions.

    See this
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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