Sumif statement in excel

I would like to do a sumif statement in excel that involves dates.

Cell A1 has a date in the format 11/15/2014. Comunm L:L has dates in the format of date and time.

If the date in greater than or equal to the date in A1 I want it to add the dates in column M.

Any ideas on how to do that?
cansevinAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
It appears you just want:
=SUMIF(L:L,">="&$A$1,M:M)
0
 
Ejgil HedegaardCommented:
A date in Excel is actually a number, so 11/15/2014 is 41958.
So when adding tomorrow 11/16/2014 (41959) the result is 83917 equal to the date 10/02/2129.
Is that what you want?

Please specify.
A sample worksheet would help.
0
 
FlysterCommented:
Are you looking to Sum the values or just get a count of the number of dates that meet the criteria? If you want a count, use this:

=COUNTIF(L:L,">="&A1)

Flyster
0
 
Rob HensonFinance AnalystCommented:
Assuming you want to extract dates from column L where it is greater than A1, in column M:

=IF(INT(L2)>=$A$1,INT(L2),"")

Copy down column M as required.

Thanks
Rob H
0
 
Rob HensonFinance AnalystCommented:
@cansevin - I assume col M does not contain dates but includes values related to the date.

If not, can I ask what you are achieving by adding up dates? As Ejgil pointed out, adding together dates just gives a larger number which represents a date further into the future.

Thanks
Rob H
0
All Courses

From novice to tech pro — start learning today.