using a cell reference in sumifs

[Jai]

Hi,

I want to use

=SUM(SUMIFS(W:W,L:L,{"DR","SS"},S:S,B5))

which works but I want the {"DR","SS"} arguement to come from a cell
reference. i.e =SUM(SUMIFS(W:W,L:L,C5,S:S,B5)) where C5 is {"DR","SS"}.
Unfortunately this isn't working for me. Any suggestions? Thanks.

 

[Bob Greenblatt]

Hi,

I want to use

=SUM(SUMIFS(W:W,L:L,{"DR","SS"},S:S,B5))

which works but I want the {"DR","SS"} arguement to come from a cell
reference. i.e =SUM(SUMIFS(W:W,L:L,C5,S:S,B5)) where C5 is {"DR","SS"}.
Unfortunately this isn't working for me. Any suggestions? Thanks.

The problem is that a cell can not contain more than one value as you seem
to be trying to do with C5. Can you not put DR in C5 and SS in C6, and have
the formula read =SUM(SUMIFS(W:W,L:L,$C$5:$C$6,S:S,B5)). Try array entering
the formula.