I have a list of about 100 names in column A, and a value in column B. I am currently using a sumif function to add all the numbers matching one of the names. How do I add the ones that do not match? Such as if I do not have the name Brock in my list, it's value will not get added, but I want it added to a row at the end of my names list, listed as Other, that gathers it and any other non used name's value.
Post a sample workbook with any confidential data
Punnam
The upload isn't showing, so I'll copy/paste a short example
MW MWh
Accokeek 1 0 0.00
Bannister 11 0.08693 128.02
Bensville 21 0.05071 72.43
Bertha 11 0.0131 16.14
Bertha 12 0.228765 284.04
Bolton 23 0 0.00
Cedarville 1 0.0225 35.93
Cedarville 2 0.06104 88.37
Dukes Inn 22 0.03168 49.11
Dukes Inn 23 0.0099751 13.55
Other
Bertha 21 0 12,320
6765 Lex Park 0 33,141
Bertha 11 4 4,928
LaPlata 11 5.43 8,131
Piscataway 23 3.42 4,213
La Plata 21 4.37 5,384
Hollywood 11 7 8,624
Bertha 11 9.1 11,211
Dukes Inn 23 6.65 8,624
Dukes Inn 23 3.325 4,928
Bannister 24 3.6 4,435
Bertha 12 13.4 16,509
The top uses my sumif to add values in bottom set. If there is a name in the bottom set that does not match the top, I want it added into the row labeled other.
Hi Mistrmoto,
Welcome to the forum.
Can you plz send your working file to help us to understand your problem and requirement.
Rgd
RT
If my answer(s) helped you, please add me reputation by click on *
You could just do
=SUM(allvaluesof2ndtable)-SUM(cellswithsumifformulasinfirsttable)
You are absolutely right, but I was hoping to be able to use something similar to a sumif.Originally Posted by Jonmo1
Why?
That's just going to create extra unnecessary calculations for Excel to do = slower performance.
Excel has already done all the required work with the sumifs finding the ones that DO match.
No need to do more work to 'find' the ones that don't match.
Simple logic says what remains after the sum of values that DO match, is the values that don't match.
Last edited by Jonmo1; 07-25-2014 at 09:25 AM.
Use pivote table for your requirement.
Or upload a sample file
Click "Go Advance" Button below, find "Manage Attachment" Button, upload your file and send.
Use pivote table for your requirement.
Or upload a sample file
Click "Go Advance" Button below, find "Manage Attachment" Button, upload your file and send.
rajechturaha, I think my network settings at work will not allow me to upload anything. When I get home I can recreate an example and upload then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks