yogi_In Table A:K Count Number Of Instances Of Each Entry In Column K

Google Spreadsheet   Post  #2014

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-10-2016

post by: MSG Crane:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/umbbrIQPzVU;context-place=forum/docs
Using multiple "count() where" arguments in a Google Query
Team,

Hoping for a little help...  I am building a charts dashboard and one of the charts is a line chart depiction of the total number of records that meet the following criteria in column "K":  "Start Usage", "Midpoint", and "End Usage".

In the end, I would like the query result to show the following so I can graph each submission type with different lines on the chart:

|    A   |                     B                  |                 C               |                 D                   |

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

|Date | Count of Start Usage | Count of Midpoint | Count of End Usage |

I feel like the way to do this is three iterations of count() where K = "???" on column D.  I can get it to work with one iteration of "count() where" but I cannot figure out how to get it to work three times in the same query... 

This works:

select A, count(D) where K = 'Start Usage' group by A

Query as it stands right now with coloring for clarity (need help):

select A, count(D) where K = 'Start Usage' label 'Count of Start Usage', count(D) where K = 'Midpoint' label 'Count of Midpoint', count(D) where K = 'End Usage' label 'Count of End Usage' group by A

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

yogi_Transpose Cross Tabbed data Into DataBase Style Layout

Google Spreadsheet   Post  #2013

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-09-2016

post by: aaron urban:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/hIaF4nvc_Bo;context-place=forum/docs

Index and Match?

https://docs.google.com/spreadsheets/d/1aZKphjUWSy5KcLT8YlRx62e-SUzUCwR7MzOJDwot3DM/edit?usp=sharing

I am trying to re arrange the information in a table and am stumped as to which functions to call.  I am looking for a specific output.

Any help would be greatly appreciated.

Thanks in advance!!!
-------------------------------------------------------------------------- 

yogi_Compute Row By Row Count Of Number Of Students Registered In Classes Listed In Columns F:K

Google Spreadsheet   Post  #2012

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: shcptech:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/osHoc8Nbm2o;context-place=mydiscussions
Count number of non-blank cells with an array?
I saw this asked in another discussion, but the formula did not work for me.

https://docs.google.com/a/shcp.edu/spreadsheets/d/1N6xy4DkhHbP9qndwpSXefc4wjIfASNk1fpwmTgAEJGw/edit?usp=sharing

I would like the first column to count the number of non blank cells in columns F-K and put the result in column A.data in the cells will constantly be updating, and in fact, at some point the contents will be numbers, and I would want to add the values in cells F-K and put the sum in Column A.

Thanks for your help!

Tim

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

yogi_Compute Month By Month Amount Spent And Running Balance Remaining From Monthly Budget Amount

Google Spreadsheet   Post  #2011

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: David Leichter:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/JEbGnQTIGjg;context-place=mydiscussions
Show Purchases Totaled for Each Month SUMIFS

I want to track spending, and make sure I stay under my organization's monthly budget.

Sheet Example

As you can see in the example below, Column A contains the dates a purchase was made, Column C contains the total amount. Over in Column G, I have the months of the year and in column H is the total spend for each month.

In Column H I have a formula that works, but I wonder if there is a more elegant solution:

=SUMIFS(C$2:C, A$2:A, "<2/1/2016", A$2:A, ">12/31/2015")

This causes all of the purchases with a January 2016 Date to be summed next to January. I then cut and paste this formula down the column manually changing the date range in the formula each time.

I tried all the following, and either got an error or $0, as my answer:

=SUMIFS(C$2:C, A$2:A, "MONTH=1")

=SUMIFS(C$2:C, A$2:A, "<2/1/2016 AND >12/31/2015")

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

yogi_Compute Row By Row Dollar Amount Of item Ordered With Prices In Column B And Order Dates In C:I

Google Spreadsheet   Post  #2010

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: R SIC:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/AS4HB1gJlo8;context-place=forum/docs
need help with a pricing sheet
Hello all, I've been reading up on a lot of posts on here and have learned quite a bit.  I was wondering if there was an easier way for me to accomplish something.  I work at a bar, and have several reps that I order from.  I created sheets for my orders so I can track my spending.  I have prices in column B, and quantity in column C, and a total price in cell C12.  I was wondering if there was an easier way to calculate the pricing, rather than add (C3*B3)+(C4*B4) etc.  Something similar to the C12:G12 formula, but with the addition of multiplying the price?  This sheet is rather short, but some of mine are upwards of 50 products, and I am constantly adding more products each month.  I appreciate any help!

https://docs.google.com/spreadsheets/d/17e9jYjmKjUd4C2HeJBwDtod-zT6wuQNjeZUPQzBUZyk/edit?usp=docslist_api

(hope the link worked)

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

yogi_For Selected Truck And Corresponding Part Pull Valus For Latest Date And Mileage From Sheet 'MTTO'

Google Spreadsheet   Post  #2009

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-05-2016

post by: Eusebio Garza:

https://productforums.google.com/forum/#!topic/docs/V5pJOf2kH4w;context-place=forum/docs
Hi, want to know, how is the best way to get the last result in a spreadsheet.

Hi, im want to know the last result in a table, i put the example in the image. i cant do this with vlookup because the problem have multiple criteria, i find in a website, that MATCH & INDEX can do this, any help? I need the last result of the trucks with "Aceite 15" part.

THANKS IN ADVANCE

Captura de pantalla 2016-01-04 17.38.49.png

11 KB

yogi_Pull Row By Row Matching Items By Month And Category From Import Sheet

Google Spreadsheet   Post  #2008

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-05-2016

post by: smithbc:

https://productforums.google.com/forum/#!topic/docs/P6tiI5QsNZE;context-place=forum/docs
Index Match Multiple Criteria (rows and columns) help

Here is a sheet with my desired results: 

I'm trying to write a formula that would go in the "Forecast" Sheet  that pulls from the "Import" sheet. 

The import sheet is copy and pasted from an accounting system report. 

The forecast sheet is a budget sheet where the budgeted numbers get updated each month with the actuals from that month, but the rest of the columns remain budgeted amounts. We are trying to find a formula that could update these automatically by matching the account name and the month of the data regardless of the format of the accounting system report.

I would like the formula to match on the account name (i.e. Sales, Travel, Office Supplies, etc.) and the month. The accounting system report puts the months in reverse order, and we would prefer not to have to rearrange these each time. 

Any help is greatly appreciated.

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