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!

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