Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to update a cell in Google Spreadsheets where its value comes from another sheet and based on the date range entered with it.

Here is what the two worksheets look like in the file.

Debtor Payments Sheet

Name | Amount Recieved | Date Recieved
Joe     $2.00            1/20/2011  
Kim     $1.00            1/25/2011                   

November Name | Amount Recieved | Date Recieved Joe $6.00 2/11/2011

Debtor Payment By Month Sheet

Name | Jan   | Feb
Joe    $2.00   $6.00
Kim    $1.00

What I want to happen is:

  1. When a payment is made in a given month in "Debtor Payments Sheet".
  2. Add the amount to "Debtor Payment By Month Sheet" in the column for that month where the name matches.

With these conditions:

  • the name will only show up once in Pay by Month
  • New names will be added to "Debtor Payments" and need to be put manually or otherwise into "Debtor Payment By Month Sheet"
share|improve this question
up vote 1 down vote accepted

Basically, you need to use a few formulas to accomplish this, like:


Walk through the spreadsheet I prepared and see the formula's for yourself: file I prepared with example

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.