**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula that if the sum of a range is equal to a number in a bank say in the region of 61 - 80 a specific text is instead shown say "Client A", but if the sum fell in the region of 51 - 60 that a different text would show, for instance "client b", is there such a way or how would you go about it? I've used if sum's before but never to highlight a range. Thank you, Alastair.

Solved by V. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
06/03/2018 - 12:32

Welcome to excel got it pro.

Excelchat Expert
06/03/2018 - 12:32

I'm here to help you today.

User
06/03/2018 - 12:32

HI, hope you can help, does the query make sense?

Excelchat Expert
06/03/2018 - 12:32

Yes it does.

Excelchat Expert
06/03/2018 - 12:33

You want to show a text rather than the sum value, right?

Excelchat Expert
06/03/2018 - 12:33

If you kindly show me some sample data, I would be able to show you how to do it.

User
06/03/2018 - 12:33

yes depending on the result of the sum I need to display 4 categorys

User
06/03/2018 - 12:33

3 in a band then the final one < everything elses

Excelchat Expert
06/03/2018 - 12:34

Okay, but do construct a formula, I need to know the 4 categories and also the data if possible.

Excelchat Expert
06/03/2018 - 12:35

If you can't show me, I understand and I would show an example with demo data.

User
06/03/2018 - 12:35

ok I can't forward the s/s but can mock one up on the table to the right if that's ok?

Excelchat Expert
06/03/2018 - 12:35

That would be very helpful.

User
06/03/2018 - 12:37

So there are three criteria which depending on the selection will give a different weighted score

User
06/03/2018 - 12:37

this will give a score out of 120

User
06/03/2018 - 12:38

bandings are on the right and I could use it either changing the text of the total to read which client

User
06/03/2018 - 12:38

or another cell below showing which client while still leaving the total number, does that make sense?

Excelchat Expert
06/03/2018 - 12:38

Okay, gimme a few minutes.

User
06/03/2018 - 12:39

great, thank you

Excelchat Expert
06/03/2018 - 12:46

Please look at C8.

Excelchat Expert
06/03/2018 - 12:47

This would also require to format the Bandings table a slightly differently as shown in column I and J.

User
06/03/2018 - 12:48

Ok thank you that appears to make sense, is it possible to copy the s/s or save a copy of the fomula?

User
06/03/2018 - 12:49

That's great, thank you for the help

Excelchat Expert
06/03/2018 - 12:49

Yes, you can download the file

Excelchat Expert
06/03/2018 - 12:49

by clicking on the file menu on the top right corner.

Excelchat Expert
06/03/2018 - 12:50

[Uploaded an Excel file]

Excelchat Expert
06/03/2018 - 12:51

here is a copy of the file.

Excelchat Expert
06/03/2018 - 12:51

The session will end now.

Excelchat Expert
06/03/2018 - 12:51

You will be asked to rate me once it end.

Excelchat Expert
06/03/2018 - 12:51

A five star would be much appreciated.

Excelchat Expert
06/03/2018 - 12:51

Thanks and have a great day.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*