Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

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.
0
alex51468
Asked:
alex51468
  • 4
  • 3
1 Solution
 
Chris BottomleyCommented:
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
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 BottomleyCommented:
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 BottomleyCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now