Saturday, February 22, 2014

yogi_Conditionally Sum From Column Of Another Sheet Entries That Meet Several Specified Criteria

                                         Google Spreadsheet   Post  #1546
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-22-2014
post by ash3154 (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/5mD55N0JGu0)
=ARRAYFORMULA(if(LENB6:B); (SUM(FILTER(Sheet2!F:F; Sheet2!A:A=b6; sheet2!...)))" "))
What am I doing incorrect???
I would like to auto populate Col A with the formula in the TITLE
=ARRAYFORMULA(if(LENB6:B); (SUM(FILTER(Sheet2!F:F; Sheet2!A:A=b6; sheet2!...)))" "))
THis formula grab the sum value in row 6 and populates that value down.

ANy HELP!!!
---
Hi Yogi,

My title is not in B6:


In Col. A I am trying to auto fill a formula which get a summed total based on certain criterias.
If(LEN(B6:B); sum(Filter(QueryAllOrders!F:F;QueryAllOrders!A:A=B6;QueryAllOrders!E:E=F6; QueryAllOrders!D:D=E6)),"---")
The above formula works, but when I put ArrayFormula(If(LEN(B6:B); ......... all I get is the total of the first row and that value is filled down.

Sheet18 -- is where I am trying to perform this action.

Thanks,
Ash
----------------------------------------------------------------------------------------------------------------------------------------------------------

your formula 
=If(LEN(B6:B); sum(Filter(QueryAllOrders!F:F;QueryAllOrders!A:A=B6;QueryAllOrders!E:E=F6; QueryAllOrders!D:D=E6)),"---")

does not lend itself to be used as a multicell array formula for cells B6;B

so one way is to use the convoluted formula I have presented for cells B6:B in this post