Thanks for the help. I think I have it now.

"tjtjjtjt" wrote:

From your paragraph, these two formulas should get you your answers. To get

your data ranges set as below, you may need to alter the ranges from these

examples.

To calculate when the first column contains 1 and the second column number

is under 600:

=SUMPRODUCT(--(A2:A21=1),--(B2:B21<600))

For the first column equals 1 and the second column between 600 and 650:

=SUMPRODUCT(--(A2:A21=1),--(B2:B21600),--(B2:B21<650))

For an an explanation of what the formulas are doing:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

You may also consider playing with the FREQUENCY Function. Embedding it in

an IF statement would likely let you work with the number ranges you set up

very easily.

Hope that helps.

tj

Based on

"Russell Hampton" wrote:

Hi TJ,

This is what I am working with. So for every 1 in the list I want it to add

if the score is in a range. So given the example, how many are there that are

less than 600? THe answer is one. And for 600-650 the answer is 5. Then I

will plug this into a chart like the one below. Does that help? I appreciate

any insight you may have.

Collateral Code Credit Score

1 586

1 605

1 633

1 640

1 643

1 643

1 651

1 656

1 659

1 665

1 692

1 696

1 699

1 701

1 702

1 704

1 716

1 724

1 754

1 773

Chart example:

Jan-04

A B C D

710 + 650-709 620-649 575-619

Count Count Count Count

Unsecured Consumer Loans

Unsecured Visa Classic

Unsecured Visa Gold

New Vehicle Direct

Used Vehicle Direct

New Vehicle Indirect

Used Vehicle Indirect

First Mortgage

Second Mortgage Fixed

Home Equity Line of Credit

Member Business Loans

All Other Loans

"tjtjjtjt" wrote:

I think an example might help.

tj

"Russell Hampton" wrote:

I need to develop a matrix. I have the report with the raw data. In one

column are numbers 1-900, the other column has scores. What I need is to

count the numbers only if the score is in a certain range. I want to come up

with a chart that looks like:

A B C D

Type 1

Type 2

Type 3

I can't embed a countif, inside of a countif. Does anyone have any advice

for this one? I can share the exact report if it will help. Thank you. Russell