Thursday, April 5, 2012

yogi_Sum Up Numbers By Months For A Given Table of Dates And Numbers

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #493

user Thomas121 said: Hi, Hoping someone could help me with a formula. Where month is X add next column I want to add the figures in one column and total a certain month, so for example: 
date      | figure 
1/1/12    |  1
2 3/1/12  |  
5/2/12    | 19 
7/2/12    | 21 
Jan:        17 
Feb:        40 
Thanks in advance. It's for a basic finance spreadsheet. 
following is a solution to the problem