Sunday, January 15, 2017

yogi_Group Total From Table Of Entities And their Corresponding Amounts

Google Spreadsheet   Post  #2110
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-14-2017
question by tiledude:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/qNW8dJag7PM;context-place=forum/docs
Arrays and adding columns of data

Hello,

This formula works fine and is giving the correct prices based on AW. 

I am trying to add the data from AW.

basically trying to add another column of data.

=QUERY('Copy of 01-FBA'!4:1000, "select SUM(R) GROUP BY AW label SUM(R) 'R'")

thanks for any help :)


RAW
14.99data from AW
439.82data from AW
1169.52data from AW
299.86data from AW
194.91data from AW
14.99data from AW
169.9data from AW
209.9data from AW
49.98data from AW
39.98data from AW
304.83data from AW
174.93data from AW
144.93data from AW
99.96data from AW