yogi_Compute Row By Row Sum of Entries In Columns C To End Of Sheet

Google Spreadsheet   Post  #2069

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

question by: Ellen Lucas:

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

How can I get individual rows to automatically find the sum?

I set up a reading log minutes data collection for the students in my class.  The format is simple, I have their names on column A and then I add their time read on column, B, C, etc. 

Ideally, I would like to set up google sheets so each week when I include their weekly minutes the sheet document automatically calculates the sums in each rows for each student. My goal is to be open the document and see one student's yearly sum immediately.  I'd also like to avoid each having to go to "insert - function - sum" thousands of time during a school year. 

 

Thank you!! 

yogi_Solution For Using Query Function To Sum Values In A Column Containing Both Numeric And Textual Data

Google Spreadsheet   Post  #2068

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

question by: Lei_Mao:

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

Spread Sheet Query Error AVG_SUM_ONLY_NUMERIC
Hi All,

I'm trying to use query on spread sheet to group the sum value of a column, here is my query: =QUERY(Raw!1:1000,"select A,SUM(B) Group by (A)",-1)

however I got the alert: AVG_SUM_ONLY_NUMERIC and google doesn't return any value

Could you advise where am I wrong? do I need to reformat the data?

Here is the raw data: https://docs.google.com/spreadsheets/d/1jAgGKyXKJoTkd2g_Suyey0XISVE2Y4mI0Sft0l_5rbs/edit#gid=502618972

tab1: my query tab 2: raw data

Thanks!

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

yogi_Using INDIRECT Function With Multi Sheet QUERY

Google Spreadsheet   Post  #2067

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

question by: Elden Fenison:

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

Using the indirect function with multi-sheet query, syntax help
I have the following formula that works fine. It queries a handful of budget sheets looking for expenditures in a certain category.

=sort(query({Amazon!A2:F;Amex!A2:F;'Cash+'!A2:F;'Double Cash'!A2:F;'USB Checking'!A2:F},"Select Col1,Col2,Col6 where Col5 ='"&D1&"'"))

I would like to use the indirect function to refer to these sheets instead of spelling them out. I have cells on this sheet that contain the names of the other sheets that I want to query.

I just can't seem to get the syntax right.

I've tried this... and it doesn't work.

=sort(query(indirect(E2&”!A2:F”);indirect(E3&”!A2:F”);indirect(E4&”!A2:F”);indirect(E5&”!A2:F”);indirect(E6&”!A2:F”);indirect(E7&”!A2:F”),"Select Col1,Col2,Col6 where Col5 ='"&D1&"'"))

The sheets names I want to query are in cells E2:E7.

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

yogi_Given A Table Of Contacts Split Entries Into 'FirstName' 'Spouse FirstName' 'LastName'

Google Spreadsheet   Post  #2066

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

question by: R123R123:

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

Split Couple and Single Names from same column

Hi, I have a large sheet consisting of names similar to as seen below, both married couples with the format "(Husband) and (Wife) Last Name" as well as single individuals "First Last". How can I split the married and single names up so that I achieve the desired outcome attached below?

Thank you!

Screen Shot 2016-05-27 at 1.57.33 PM.png

14 KB

yogi_Compute Number Of Rows That Have 0 and Frog In The Same Row In Range D8:H14

Google Spreadsheet   Post  #2065

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

question by: Shaun Milliken:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/_GXPt1R0k6w;context-place=mydiscussions
question by: Shaun Milliken
Google Sheets Formula for Counting Rows Once That Have Duplicate Entries

I have searched for weeks to a solution to my problem but have found nothing helpful.  I have included a link to a sample spreadsheet that describes the problem I am trying to solve.  

I am trying to count how many rows in a spreadsheet have a zero and a specific word.  The problem is that the word is present multiple times in some rows so those particular rows are counted multiple times in the total instead of only once.  My linked spreadsheet below explains it much better with data and examples.

Thank you in advance for any help offered as I have been trying to solve this for far too long :)

Sample Spreadsheet

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

yogi_Compute Dates In Cell A2 And Down That Are Before Date In Cell A1 Skipping Weekends

Google Spreadsheet   Post  #2064

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

question by: Enzo Jonica:

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

how to change date order ????

hi  i need some help  i  want   to show a date  like  this  when i enter   say  5/6/2016   then i would like  the  order to be

5/5/2016

5/4/2016

5/3/2016

see  picture  don't know  how to change  the  order  when i enter the first  date  then the  order  come like the picture  how  can i invert the order  thanks very much 

excel google help.png

13 KB

---------------------------------------------skip the weekends Sat and Sun

yogi_For Domains In Column A Of Sheet2 Assign Highest Rating Based On 'Best' 'Good' 'Bad' From Data In Table Of Sheet1

Google Spreadsheet   Post  #2063

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

question by: agalaga:

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

Vlookup with wildcard to return highest value?

 On sheet1 - column A I have a list of URLs. In column B I have a quality rating. 

On sheet2 - column A I have domains. In column B I have the highest "quality rating". It goes from "best", "good", "bad"

On sheet2 - A2, if I type "forbes.com" I need B2 to return the "Best". If I type "businessinsider.com" in A3, I need B3 to return "Good".

I not sure how to get B2 to return the top quality rating. I've tried a number of nested if statements, vlookup, index, search and other functions but still can't figure it out.

Sheet for reference for reference:
https://docs.google.com/spreadsheets/d/1EK6svhHswWG46x8jnqXIPn0Okyv2f29m8_6DuBGjeZs/edit?usp=sharing

Thank you

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