Adding two instance in the same column

In excel we have two instances of names in a column. I need each name to give me a SUM calculation and an alert.
I will give you an example:
Name    Qty   Cell

Test 1    5      A3
Test1     5      A4
Test2     4      A5
Test2     3      A6
 I would like the SUM of A3:A4 and  A5:A6. When either name, Test 1 or Test 2, reaches 10 first i will get a alert at cell H3.
Can you help me with this. If you need further information let me know.
alex51468Asked:
Who is Participating?
 
Chris BottomleyConnect With a Mentor Software Quality Lead EngineerCommented:
Psychotec

The timing was even tighter than that ... I also refreshed immediately before posting.  Ho hum at least we gave Alex a selection of approaches!

Chris
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
For example, anything like this?

Chris
twocols.xls
0
 
ExcelGuideConsultantCommented:
see attached file and try testing by changing the values so it will go over 10. Test1 will give RED and test2 will give PURPLE....are you looking for something like this?
sample.xls
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
ExcelGuideConsultantCommented:
sorry chris, I really refreshed before posting and even it took like 3 sec for me to post I see you where like 1 sec before me.

0
 
alex51468Author Commented:
Hello Psychotec. This is what i need. Can you give me the formula for this? Thanks.
0
 
ExcelGuideConsultantCommented:
select cell H3 and then goto: "Format->Conditional Formatting". You will see the example/formula.

Good luck
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
I thought you were going with Psychotec's solution so I am glad to have helped a litle as well.

Chris
0
 
ExcelGuideConsultantCommented:
I thought that as well, but still it is ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.