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,

so all of D2:D202 must contain the T10 value and all of H2:H202 must contain a "yes" for the 2 cells to be added together? Is that the requirement?

Well, I guess I shouldn't try to help then...sorry...

.. just kidding.... no worries about the rep....

Does this work for you?

=SUM(IF(AND(COUNTIF($D$2:$D$202,"<>"&$T$10)=0,COUNTIF($H$2:$H$202,"<>Yes")=0),Task_Timings!$B$10:$C$10),Task_Timings!$B$10)

So then not all of column D has to be equal to T10 and not all of column H needs to equal Yes,

How about?

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

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Ok, how about?

=IF(COUNTIF($D$2:$D$202,$T10),SUMIF(Task_Timings!$A:$A,$T10,Task_Timings!$B:$B),0)+SUMPRODUCT(--($D$2:$D$202=$T10),--($H$2:$H$202="yes"))*SUMIF(Task_Timings!$A:$A,$T10,Task_Timings!$C:$C)

In U2, it would be:

=IF(COUNTIF($D$2:$D$202,$T2),SUMIF(Task_Timings!$A:$A,$T2,Task_Timings!$B:$B),0)+SUMPRODUCT(--($D$2:$D$202=$T2),--($H$2:$H$202="yes"))*SUMIF(Task_Timings!$A:$A,$T2,Task_Timings!$C:$C)

copied down.

I am not sure I understand you...

I thought you wanted to account for the main time once and then add the added time for each further occurance of the combination of what is in T2 and "Yes"?

Your logic seems to be changing...

Is this it?

=COUNTIF($D$2:$D$202,T2)*SUMIF(Task_Timings!A:A,T2,Task_Timings!B:B)+SUMPRODUCT(--($D$2:$D$202=T2),--($H$2:$H$202="yes"))*SUMIF(Task_Timings!A:A,T2,Task_Timings!C:C)

in U2, copied down.