Sunday, March 9, 2014

yogi_Compute Sum In Column C Based On startDate And endDate entries in Column B

                                         Google Spreadsheet   Post  #1555
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-09-2014
post by Yarra Liebermann-Cliff   (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/pjgWGpJnars)
Summing a range based on a range of dates
Hey guys,

I'm a freelance writer and I'm trying to be responsible and check my salary. To do that I've tried using Google Sheets formulas with no apparent success, so I'm turning to you.

Basically, I have column A (range name=name) with the subject of the article, column B (range name=date) with the date it was published on, and column C (range name=money) with the amount of money I received for that article.
Now, I get paid in April for every article that was published between 20/01/2014-20/02/2014. 
I want to find a formula that will calculate the sum within the range money based on the right range in date. The thing is I couldn't find the right way to do so and I really don't want to manually change the regular sum() formula when I add an item to the data...


Disclaimer: the document is in Hebrew but ranges are in English and also I'm using columns here so it should be no problem.
-------------------------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment