I'm trying to use SUMIFS in Excel 2007 as follows to evaluate multiple criteria within the same column.
=SUMIFS('September Orders'!$H:$H,'September Orders'!$F:$F,'Individual Agency Report'!$E$2,'September Orders'!$P:$P,{"16*","30*"},'September Orders'!$C:$C,"<>*CSFP*")
This formula should work fine, I think--but the section in bold returns the sum only for the first criteria listed in column P--such that September Orders'!$P:$P,{"16*","30*"} returns the same tally as if the formula were September Orders'!$P:$P,"16*" and September Orders'!$P:$P,{30*","16*"} returns as if it were September Orders'!$P:$P"30*".
The solution using the {bracketing} came originally from Daddy LongLegs on this post: http://www.excelforum.com/excel-form...ne-column.html
Bookmarks