How to query and sum unique values using google Sheets-CodePudding

Home > database > How to query and sum unique values using google Sheets

How to query and sum unique values using google Sheets

Time：02-02

I am trying to query a table and the 2 first columns should be used as reference, where the second column (user) should be unique as reference in the column A and the other columns should be summarized. This is my table:

If you want to rename the headers, add at the end of the query: label SUM(E) 'VALUE_RECEIVED', SUM(F) 'Payable 10%' and so on

Page link：https//www.codepudding.com/database/690115.html

Prev:google sheet query error AVG_SUM_ONLY_NUMERIC

Next:Is there any function to add date to specific cells?

Tags：

google-sheets

Links：
CodePudding