Results 1 to 15 of 15

Summing based on several conditions

Threaded View

  1. #1
    aiwnjoo
    Guest

    Summing based on several conditions

    I have used various formulas but cannot get it right its annoying me now;

    Tried:

    =SUM(IF($D$2:$D$202=$T$10,Task_Timings!$B$10+SUM(IF($D$2:$D$202=$T$10,IF($H$2:$H$202="Yes",Task_Timings!$C$10)))))

    Tried:

    =SUM(IF($D$2:$D$202=$T$10,Task_Timings!$B$10),SUM(IF($H$2:$H$202="Yes",Task_Timings!$C$10)))

    Seems to just calculate random figures and sum everything up wrongly.

    What it should do is;

    IF D2:D202 contains whatevers in T10 AND H2:H202 contains the word "Yes" it will then add together Task_Timings B10 and C10. But IF H2:H202 contains nothing then it should just give the Task_Timing B10 value.

    Thanks,
    Last edited by NBVC; 08-05-2010 at 09:38 AM.

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