[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2798
  • Last Modified:

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!!
0
Curtis Long
Asked:
Curtis Long
1 Solution
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now