using a cell reference in sumifs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jai - 29 May 2008 03:33 GMT

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.

Reply to this Message

Bob Greenblatt - 29 May 2008 13:15 GMT

On 5/28/08 10:33 PM, in article
B2785D10-7105-450B-849E-5FF226C4EC6A@microsoft.com, "Jai"

> Hi,
>
[quoted text clipped - 5 lines]
> 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.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / May 2008

using a cell reference in sumifs