If Cell is between specified dates then perform sum how?

NauticaX

New Member
Joined
Feb 4, 2005
Messages
13
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
NauticaX said:
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

Code:
=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

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Try this:
Book1
CDEFGHIJKLMNOPQRSTUVW
4Start1/15/2006
5End1/31/2006
651/20/2006210-3
Sheet1


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

Watch MrExcel Video

Forum statistics

Threads
1,118,826
Messages
5,574,530
Members
412,601
Latest member
TheBeaniacExpress
Top