Hi
I look for the way to sum all sales and all deals from google sheet:
Sheet 1
Product namePriceSales dateMonthYearSales priceDealA63.001/3/20131201312013
116.0053.00B74.0010/9/2013102013102013200.00126.00C300.007/20/20137201372013
400.00100.00D74.0010/9/2013102013102013131.0057.00A74.005/6/20135201352013
116.0042.00C300.004/3/20144201442014400.00100.00F74.0011/13/2013112013112013
131.0057.00G88.002/26/20142201422014300.00212.00A74.001/14/20141201412014
116.0042.00
Sheet 2 Result sheet
1201322013320134201352013620137201382013Salesformulaformulaformulaformula
formulaformulaformulaformulaDealformulaformulaformulaformulaformulaformula
formulaformula
In the result sheet I want to use sum and vlookup. In sales for 12013 the
formula should look in to MonthYear column in sheet1 and sum all SalesPrice
from 12013.
I figure out that the formula should contain this function:
sum(iferror(arrayformula(if(),vlookup({}*sign(),false)))))))
look at the example:
https://docs.google.com/spreadsheets/d/1FxgAFoWp81P-sM45DkM1lS5dO74WAhtrCkfvhmc8pQA/edit?usp=sharing
Look for your support!
Regards P.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
