PC Review


Reply
Thread Tools Rate Thread

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.

TIA for your help!
Sam
 
Reply With Quote
 
 
 
 
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.
>
> TIA for your help!
> Sam



 
Reply With Quote
 
 
 
 
=?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

>
>
>

 
Reply With Quote
 
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

> >
> >
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a SumIf range not a range ... but a sum of specific cells JPD Microsoft Excel Discussion 3 4th Feb 2010 09:31 PM
How do I enter formula sum(range+range)*0.15 sumif(range>=3) tkw Microsoft Excel Misc 2 1st Oct 2009 09:17 PM
SUMPRODUCT or SUMIF if any values in a range equal any values in another range PCLIVE Microsoft Excel Worksheet Functions 3 15th Jul 2009 07:43 PM
SumIf - when I fill down the Range, Criteria & sum range changes markholt Microsoft Excel Worksheet Functions 3 28th Oct 2008 01:37 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:05 PM.