I have a list that consists of many similar codes, these codes also have a mileage associated with each one. I want to get a summary of this list with a breakdown of miles. I have a copy of this attached. I am looking for the equation to write that will search for each "code" (ALB is an example) and count the number of instances that "ALB" has mileage under 15 miles and input that sum in the cell designated.
I hope this makes more sense.
Chris Nelson
Last edited by Chrisnelsonusa; 06-06-2005 at 02:26 PM. Reason: clarification
Hi!
To count how many times the code mileage is less than 15:
With codes in column A and mileages in column B:
=SUMPRODUCT(--(A1:A20="code"),--(B1:B20<15))
To count mileages between ranges: 15 to 50 inclusive:
=SUMPRODUCT(--(A1:A20="code"),--(B1:B20>=15),--(B1:B20<=50))
Biff
"Chrisnelsonusa"
<Chrisnelsonusa.1q7myb_1118070303.9718@excelforum-nospam.com> wrote in
message news:Chrisnelsonusa.1q7myb_1118070303.9718@excelforum-nospam.com...
>
> I have a list of codes that has a number associated with it on the
> right. I wish to write an equation that counts the number of codes on
> the left that fall within a certain grouping of the numbers on the
> right. This does not make much sense as I retype it and try to figure
> out a better way to explain it, so I have attached a sample of what I
> am working on.
>
> Thanks in advance,
>
> Chris Nelson
>
>
> +-------------------------------------------------------------------+
> |Filename: Sample.txt |
> |Download: http://www.excelforum.com/attachment.php?postid=3461 |
> +-------------------------------------------------------------------+
>
> --
> Chrisnelsonusa
> ------------------------------------------------------------------------
> Chrisnelsonusa's Profile:
> http://www.excelforum.com/member.php...o&userid=24072
> View this thread: http://www.excelforum.com/showthread...hreadid=376778
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks