Thread: Comparing, Matching, and Sum formula
View Single Post
  #1  
Old April 30th, 2010, 12:55 AM posted to microsoft.public.excel.newusers
MA
external usenet poster
  
Posts: 23
Default Comparing, Matching, and Sum formula
Hello.

Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.

Column B has numbers

Please, provide me the formula IF:

column A="2010-04-29" then SUM(B:B)

Thank you.