yogi_Compute Week By Week Total Of Columns B D And F

                  Google Spreadsheet   Post  #1782
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-06-2014
post by  Jen-Lars:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/4qDFg3uUwJg)
How to sum data by week using google spreadsheet

I'm trying to add all the totals of "B", "D" and "F" and get a weekly total, for each week on this sheet.

I tried using this answer but the columns are different, and I can't figure out what to change.

Ideally I would get weekly totals each Sunday.

Columns are:

A dates

B daily expenses $

C cumul. budget

D daily subscribers

E cumul. subscribers

F daily $ avg

----------------------------------------------------------------------------------------

yogi_Pull Latest Non-Blank JobStatus For A Specified Name From Table Of Name_ And_JobStatus

                  Google Spreadsheet   Post  #1781
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-06-2014
post by  LT27:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/H6XKWrqE9l4)
Show Only Last Entry in Filter Formula

Hello!

I am using a simple filter formula to show information from a larger spreadsheet.

I have =filter(Sheet2!B:B,Sheet2!A:A=A13)

Sheet 2 has all of the information. Row B is the job status. Row A is the name. A13 is the name I want to match!

For example

Name             Job Status

Jane Doe        In Process

Jane Doe        Informal Offer

Jane Doe        Official Offer

I would like a formula that only displays the LAST job status! So, I would only want Official Offer to show up on the sheet with the formula. 

I attached photos!

Thanks much!

----------------------------------------------------------------------------------------------------------------------

yogi_Calculate Age In Years And Months

                   Google Spreadsheet   Post  #1780
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-06-2014
post by  Allie Choudhury:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/OTjPT_RzF3E)
Age in years and months

I am trying to convert birth dates in one column to year and months in the next column but I am having trouble getting it to work.  Any suggestions on formulas I could try?  I tried the ither suggestions posted but they are giving me just months or just years.  Thank you!

---------------------------------------------------------------------------------------------------------------------------- 

yogi_Compute Average Number Of Purchases By ItemID For a Given Range Of Dates

                   Google Spreadsheet   Post  #1779
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-27-2014
post by  QuickQuestionPlz:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/WBWTlUJ5WnE)
Please help with populating a column with data from other columns based on a condition
Hello all,

I'm a bit new to using Docs for spreadsheets, and was wondering if I could get some help really quick. Also, my apologies if I haven't worded this very well. Here's the scenario:

I'm working with some simple sales figures, and I want to know how to use some simple formulas for separating the data based on certain conditions. Here is a sample of the data I'll be working with:

date	itemID	purchases	buyers
1/1/2014	1	10	7
1/2/2014	1	8	6
1/3/2014	1	13	8
1/1/2014	2	6	3
1/2/2014	2	6	4
1/3/2014	2	5	3
1/1/2014	3	2	2
1/2/2014	3	1	1
1/3/2014	3	3	3

I want to write a formula that figures out the average purchases for each item for between two dates. However, I will be working with thousands of items. Basically, the formula would populate a column like the Average Purchases column below, except it would do so for thousands of items instead of just 3.

Date Range	ItemID	Average Purchases
1/1/2014 - 1/3/2014	1	10.33333333
1/1/2014 - 1/3/2014	2	5.666666667
1/1/2014 - 1/3/2014	3	2

Any help is greatly appreciated! Thanks!
------------------------------------------------------------------------------------------------------------------------

yogi_Query A Data Set By Roster For Different Teams

                    Google Spreadsheet   Post  #1778
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-27-2014
post by  Kat E.:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/235TeBWmBfc)
How to correctly query a data set by roster

Hi there,

This is probably pretty novice, but I'm having a really tough time figuring out how to query a set of data to isolate entries that correspond in part to other (mutually exclusive) data sets.

To be more clear, I have a list of names and associated attributes. These names are of people on different teams, and no person is on multiple teams.

Goal: To make the data more manageable, I want to automate breaking the data set into team, based on the name of the person, which is contained in both a team roster as well as the data set in question.

Here's an example, where "Master response sheet" is the data in question, the rosters of two teams (Edible and Animal) are available, and the desired destination sheets are called "Registration and color info for team Edible" and ""Registration and color info for team Animal". I've tried =QUERY(Master_response_sheet!A1:A5, select A,B,C when A1!A5 contains 'team_edible_roster!A1:A6') to pull the data in for Team Edible, but that's definitely not correct.

Once you stop giggling at my incompetence, any help would surely be appreciated ;)

Warm regards,

Kat

------------------------------------------------------------------------------------------------------------------------------

yogi_Calculate Percent Difference Of Circulation Compared To Last Month

                    Google Spreadsheet   Post  #1777
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-27-2014
post by  Solder:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/YOqaZh3Effk)
How do I calculate a growth percentage over one column

Hi

I've seen lots of formulas for calculating percentages across multiple rows....but I need to calculate change across just one column using one set of numbers. Can somebody please explain the right formula for how to do this?

I've attached a link to the spreadsheet below. Any help would be most appreciated!!

https://docs.google.com/a/soldsie.com/spreadsheets/d/1N1wOjB99qUJrEz2BCMWJd4kGVrZK8qbanGgWnuaJzxQ/edit#gid=0

- Joe

---------------------------------------------------------------------------------------------------------------------

yogi_Formula To Display Latest Date In Column A That Correlates With A Value In Column B And Column C