Reply to Message

SUBTOTAL() will always evaluate as an array function
so if one of your range references is like A1:A99="Y" then there's no need to press CTRL-SHIFT-ENTER

btw you might want to use this array funtionality to create a COUNTIF/SUMIF type function for multiple conditions
eg SUBTOTAL(9,range1=condition1,range2=condtition2,range3) will sum only the values in range3 that meet the specified criteria in range1 and range2