Friday, September 27, 2013

yogi_For Budget Spreadsheet Set Up Amount Expended Sheet For Each Month of The Year

                                          Google Spreadsheet   Post  #1378
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 27, 2013
user  Al_searching (http://productforums.google.com/forum/?zx=lenf7csdi1jt#!mydiscussions/docs/Z6tl_yFaAIs)
Data sorting by month + category
Hello Everyone,

This is for a monthly budget spreadsheet associated with a google form.

I'm using the following formula to pull data from the form tab to another tab in the same spreadsheet : =SUMIF(Category,A65,Price)
where Category = a specific category from the associated google form, A65 is the cell in which that same category is displayed on the second tab, and price is the price sum added. 

For instance if there are 4 items of $3 each in the category "Groceries" that have been entered in the form, the number displayed in the cell with =SUMIF(Category,A65,Price) is $12

Now what I'd like to do is create several tabs, one for each month of the year, and have the data from the Google form sorted in each tab according to the month.

For instance all the items entered in september go in the "september" tab, all the items entered in october go in the "october" tab and so on.

Do you know what formula I need to enter along with =SUMIF(Category,A65,Price) so that it also filters the data according to the month ?

Thanks, any help is appreciated
---
Thanks for your answer Yogi! I'm not that familiar the QUERY function. Here's the link the the spreadhseet : https://docs.google.com/spreadsheet/ccc?key=0AsCa64sWf_X5dG1SU0gwVlpvOXVFUUZhY3BkUHg4QlE&usp=sharing

Thanks in advance and have a good one!
-------------------------------------------------------------------------------------------

No comments:

Post a Comment