Sumif and a range

[Metolius Dad]

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

[Bob Phillips]

=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

[Metolius Dad]

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

[Bob Phillips]

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