Hi,

I have a worksheet where I need to create a running total based on values of fields

Cell A Cell B Cell C Cell D
Apple 123 13 10/1/13
Apple 123 14 10/5/13
Apple 456 4.5 10/3/13
Orange 123 6 null
Orange 123 7 10/1/13
Orange 123 8 10/5/13

In theory, in Column E I'd like to have the formula: =sumifs(C:C,A:A,A2,B:B,B2,D:D,<=D2)

My Sum range is Column C, and my Criteria is Column A, Column B, and Column D....but for Column D I only want it to sum the values of Column C if the date in Column D is <= the date in cell D2 (assuming all other criteria is met).

I can't figure out how to use operations such as <> or Equal To within a Sumifs formula. Is this possible, or is there another way?

Thanks