You need

=SUMIF(A:A,"<="&D10,B:B)-SUMIF(A:A,"<="&D9,B:B)


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Metolius Dad" <MetoliusDad@discussions.microsoft.com> wrote in message
news:C46E95C1-C63D-433F-B642-0EFA26777B06@microsoft.com...
> This works well, however, can I push a bit more and ask how I can do this
> same task but being able to use the portion in quotes as a reference. As
I
> experimented =SUMIF(A:A,<=D10,B:B)-SUMIF(A:A,<=D9,B:B) with col D being
the
> limits of each range didnt work.
>
> Again, thanks for any assistance.
> Sam
>
>
> "Bob Phillips" wrote:
>
> > =SUMIF(A:A,"<=5",B:B)
> >
> > =SUMIF(A:A,"<=10",B:B)-SUMIF(A:A,"<=5",B:B)
> >
> > etc.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Metolius Dad" <MetoliusDad@discussions.microsoft.com> wrote in message
> > news:639A6CF0-95EC-4CE5-85A6-F531F8C79FC1@microsoft.com...
> > > Hello Wizards,
> > >
> > > Col a has 200 - 300 entries limited to the integers 1 - 20 . Col b has
> > > values associated with col a numbers. What do I use to get the sum of
the
> > > values in col b that are associated with a's digits 1-5, 6-10, etc.
> > >
> > > TIA for your help!
> > > Sam
> >
> >
> >