Prev: Lookup function
Next: Lookup and multiple criteria
From: aprendiz on 15 Feb 2010 10:15
I have an spreadsheet with columns like:

col A col D col E colF
B230 8 1 0
F001 -5 0 10
F002 3 20 0
F010 5 -29 3
F014 40 3 7
F020 -25 -6 -100
F113 0 0 0
H002 34 -50 23
in ascendent order.
I want to be able to Sum col D to colF if colA is between F001 and F020
except F010.
I am just starting with this and I really don't know how to mix and match
all the formulas. any help will be much appreaciated!!
Thanks in advance.
From: macropod on 15 Feb 2010 11:55
See reply in microsoft.public.excel.misc

And please don't post the same question multiple times in different newsgroups - you can post to multiple newsgroups simultaneously,
if need be, so that an answer in one newsgroup propagates to all.

--
Cheers
macropod
[Microsoft MVP - Word]


"aprendiz" <aprendiz(a)discussions.microsoft.com> wrote in message news:2DE04990-2D2E-4B63-9921-F4E08F5143DE(a)microsoft.com...
>I have an spreadsheet with columns like:
>
> col A col D col E colF
> B230 8 1 0
> F001 -5 0 10
> F002 3 20 0
> F010 5 -29 3
> F014 40 3 7
> F020 -25 -6 -100
> F113 0 0 0
> H002 34 -50 23
> in ascendent order.
> I want to be able to Sum col D to colF if colA is between F001 and F020
> except F010.
> I am just starting with this and I really don't know how to mix and match
> all the formulas. any help will be much appreaciated!!
> Thanks in advance.

 | 
Pages: 1
Prev: Lookup function
Next: Lookup and multiple criteria