Prev: Autofit height
Next: VLook-Up Possibly Conditional Formatting
From: JLatham on 5 Mar 2010 16:54
Not in this case. The limit is the number of characters that can make up a
formula. That is 1024 in Excel 2003.

You are thinking of nested formulas when you mention 8. It's actually 7
levels of nesting, which gives you 8 options.

"Seanie" wrote:

> Is there any limit to the 'longish' formula? Something tells me 8 is
> the limit
>
> .
>
From: Dave Peterson on 5 Mar 2010 16:59
Another:

=SUM(SUMIF(B:B,{1,2,3,4,5},D:D))



Seanie wrote:
>
> Thanks, that would be ideal if I could do =SUMIF(B:B,1,2,3,4,5,D:D),
> but it only takes 1 criteria

--

Dave Peterson
From: JLatham on 5 Mar 2010 21:17
Dadgummit! I almost went there. Stopped before adding the outside SUM(), it
didn't work as an array formula, so I went with the individual SUMIF()s.

Hope OP sees your post.

"Dave Peterson" wrote:

> Another:
>
> =SUM(SUMIF(B:B,{1,2,3,4,5},D:D))
>
>
>
> Seanie wrote:
> >
> > Thanks, that would be ideal if I could do =SUMIF(B:B,1,2,3,4,5,D:D),
> > but it only takes 1 criteria
>
> --
>
> Dave Peterson
> .
>
From: Seanie on 6 Mar 2010 02:36
Thanks guys

From: Seanie on 6 Mar 2010 06:13
A further twist on =SUM(SUMIF(B:B,{1,2,3,4,5},D:D))

How could I incorporate a further criteria eg. If ColA contains
"London" and if ColB contains one of 1,2,3,4,5 then add up all those
instance in ColD




First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Autofit height
Next: VLook-Up Possibly Conditional Formatting