If Cell is between specified dates then perform sum how?

[NauticaX]

I tried search and googling but I can't seem to figure out how to do it with dates.

I would like to perform this =-P6+C6+U6 in say Cell W6 but only if

Cell D6 has a date greater then 1/15/06 but less then or equal to 1/31/06

Would I use the SUMIF function?

TIA

 

[just_jon]

I tried search and googling but I can't seem to figure out how to do it with dates.

I would like to perform this =-P6+C6+U6 in say Cell W6 but only if

Cell D6 has a date greater then 1/15/06 but less then or equal to 1/31/06

Would I use the SUMIF function?

TIA

Try

=IF(AND(D6>X1,D6<X2),C6-P6+U6,"")

Where X1 and X2 hold your start and stop dates.

Edit for code tags...

 

[Barry Katcher]

Try this:

Book1
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
4																				Start	1/15/2006
5																				End	1/31/2006
6	5	1/20/2006											2	10							-3
Sheet1

Coises! Beat to the punch again. Oh well, it was just jon.

 

[NauticaX]

SWEET! That works thanks a lot. If I could give you guys a hug I would

 

[just_jon]

SWEET! That works thanks a lot. If I could give you guys a hug I would

Even after seeing Barry's gif?

 

[Barry Katcher]

...or just jon's avatar? Keep on smilin', dog.