# Sumif and a range

=?Utf-8?B?TWV0b2xpdXMgRGFk?=
Guest
Posts: n/a

 10th Feb 2006
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.

Sam

Bob Phillips
Guest
Posts: n/a

 10th Feb 2006
=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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> Sam

=?Utf-8?B?TWV0b2xpdXMgRGFk?=
Guest
Posts: n/a

 13th Feb 2006
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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
Guest
Posts: n/a

 14th Feb 2006
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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

> >
> >
> >

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post JPD Microsoft Excel Discussion 3 4th Feb 2010 09:31 PM tkw Microsoft Excel Misc 2 1st Oct 2009 09:17 PM PCLIVE Microsoft Excel Worksheet Functions 3 15th Jul 2009 07:43 PM markholt Microsoft Excel Worksheet Functions 3 28th Oct 2008 01:37 AM Oscar Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:01 AM

Features