Try something similar to:

=if(and(A2=A1,C2=C1),D2-D1,0)

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England
"Michael Saffer" wrote in message
...
Dear folks,

I have used either the "andif" or is it "ifand"? function before, but for
the life of me right now
I can't remember the right way to make this work. This is my huge problem
de jour.


A B C D E
101940 1/13/2006 Friday 280
101940 1/20/2006 Friday 250 ?
101941 1/14/2006 Saturday 280
101941 1/21/2006 Saturday 280 ?


I have to show the difference between D2 and D1 in cell E2 but only if A2=A1
and C2=C1.

I have to show the difference between D4 and D3 in cell E4 but only if A4=A3
and C4=C3.

The correct answers would be E2 = -30 and E4 = 0

Thank you very much. I really appreciate it.


Michael Saffer
Jacksonville, Florida