Need formula to set range of numbers to auto populate a count in diffrent cell

[gmc408]

I'm setting up an excel worksheet to determine how many peoples with different credit scores. I want to input a row of scores, with different ranges of numeric amounts. Example: 350 - 600, 601 - 699, 700 - 850.

When the scores are entered I'm looking for a tally up total for each. Then I want to have three cells with the tier total amounts for each. Example: Credit score with "A" credit, "B" credit, "C" credit.

Can this be done with multiple functions or this needs to be a string of one function?

I'm very new to excel and in need for some good advice.

Thank you.

 

[Drumstick22]

In three separate cells enter:

=COUNTIFS(A:A,">=350",A:A,"<=600")

=COUNTIFS(A:A,">=601",A:A,"<=699")

=COUNTIFS(A:A,">=700",A:A,"<=850")

Change column A:A in the formula to whichever column contains credit scores.

Hope this helps.

D

 

[FDibbins]

Perhaps try this. Note that you need to keep the data ranges separated, don't combine them (they then become text, not numbers)...

	A​	B​	C​	D​
1​	657​		0​
2​	442​		350​	1​
3​	538​		600​	9​
4​	611​		700​	6​
5​	729​		850​	4​
6​	531​
7​	824​
8​	304​
9​	462​
10​	480​
11​	644​
12​	614​
13​	355​
14​	503​
15​	676​
16​	815​
17​	796​
18​	633​
19​	499​
20​	528​

D2=COUNTIFS($A$1:$A$20,">="&C1,$A$1:$A$20,"<"&C2)
copied down