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 :)

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