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:

https://docs.google.com/spreadsheet/ccc?key=0An1zl_-acWfhdHp1bFFWeEdKNVYwdTE2X0xKWHNrQkE&usp=sharing

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