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.
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.