SUMIF EXCEL 2010

If I have a column with a date in it and a column with a number, how do I format my equation to sumif the date =8-1-2012??

Thanks!!
Curtis LongAsked:
Who is Participating?
 
tdlewisCommented:
If the dates were in the range C2:C10 and the numbers in D2:10 then:

=SUMIF(C2:C10,DATE(2012,8,1),D2:D10)
0
 
Curtis LongAuthor Commented:
Cool!!

Can I use a cell as the date??  So if in a1 I type 8-1-2012 it sould show the data for that date, then if I change the date it would update??

Thanks for your help!!
0
 
barry houdiniCommented:
Yes, you can just replace the DATE part of tdlewis' suggested formula with the cell reference, e.g.

=SUMIF(C2:C10,A1,D2:D10)

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.