Sum if multiple Criteria is true

I want to get a sum of a group of cells if multiple criteria is true.

Column A is the same "Date", and Column B is the same "Line", and column D is the same "Shift",

So if each row has the same Date, Line, and Shift, I want the sum of column "E" for those respective rows to go in column F for those respective rows.

Hope that makes sence, see attached for example, notice Shift changes...

**EDITED
Please note I need to do this in an Excel 2003 atmosphere.

what do you mean by if each row has the same date, line and shift?

If row 2 and row 3 share the same date, same line, and same shift, then sum the value in cell E, and put the result in cell F.

But row 2,3,4,5,and 126 could share those same 3 values, and then I would need the sum of them.

are the numbers in column F in your sample file true?

If I did my math correctly, Column F should be accurate.

Here, try this:

=SUMIFS($E$2:$E$1000,$A$2:$A$1000,A2,$B$2:$B$1000,B2,$D$2:$D$1000,D2)

Extend range as you need but you must have same ranges

Works great in the newer versions of excel, but will not work in older versions.

I forgot to mention that I will be using this formula in a 2003 excel environment and will need it to work accordingly. So although the above code will work, it will not in the environment I need it to, any other thoughts?

Try :

=SUPRODUCT($E$2:$E$1000, --($A$2:$A$1000=A2), --($B$2:$B$1000=B2), --($D$2:$D$1000,D2))

However, SUMPRODUCT formula is quite a slow so it would be better to create new column (F) where you could CONCATENATE columns A, B and D and then you can use SUMIF formula in 2003.

If you would use SUMPRODUCT formula keep your range at minimum ($1000 part)

Thank You for providing each method, I do agree I think I may add the helper column and go that route. It works, Thanks again!