Has anyone figured out any alternative combination of functions for the “Sumifs” function?
I need to do a sum based on two criteria.
LittleMalky (BOB member since 2012-03-20)
Welp, the obvious answer is to pass two criteria back into your webservice, so return on the data you need.
Outside of that, you can structurally build a sumif situation using multiple worksheets.
Data is incoming on Worksheet 1.
Workseet 2 - Index(Match(Or())) functions analyze Worksheet 1.
If(Sum()) functions go on workshset 3.
Babystepping your complex formulas across excel worksheets is safe for the SWF, because Excel will calculate each worksheet separately. When it does this…Xcelsius wont be trying to create arrays…which SWF’s were never designed to handle.
Cairmor 
(BOB member since 2008-06-05)