using a cell reference in sumifs

J

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.
 
B

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.
Click to expand...
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.
 
Top