Sum of unique/distinct values of a filtered column

Excel_s_o · 27. Januar 2023

Hi CommunityI would like to have a cell of the sum of the budget which updates automatically when you set the filter. Here, every market's budget will count only once. In the example below the sum would be 12+8+5 = 25.If I would filter after A and B, the cell should show a value of 12+8 = 20.Does anyone have an idea who I could solve it?Many thanks in advance.MarketBudgetAnnaA12PeterB8JuliaC5MarcusB8MariaA12

xps350

You are right about numbers not needing quotations marks.

In this case the marks are not delimting numbers, but parts of the sql-string:

- "INSERT INTO tblDetail ([Pid], [Bid]) VALUES ("

- ", "

- ")"

The string is build in this way because it consists of fixed parts (see above) and variable parts (the
values of lngProductID and lngBID).

Irish Beast

und eine noch eventuel duemmere Frage, das klappt nur so einfach wenn der Referenzbereich von A: ist.

Wenn er aber von F: ist dann muesste ich so arbeiten

=VLOOKUP(C2,F:G,SUM(COLUMN(G:G)-COLUMN(F:F))+1,FALSE)

richtig? Oder gibt es da einen noch einfacheren Weg?

Vijay_Verma

Hi Fatima

Greetings! I am Vijay, an Independent Advisor. You can use VLOOKUP very easily.

Let's say that your second list has list of items in column E (please change E appropriately). Data starts in row 2.

And first list in column A and B of same sheet. Use following formula and drag down

=VLOOKUP(E2,A:B,2,0)

More robustly

=IFERROR(VLOOKUP(E2,A:B,2,0),"")

Now there may be a scenario that first list is in Sheet1 and second list is in another sheet starting in column A.

The use following formulas

=VLOOKUP(A2,'Sheet1'!A:B,2,0)

=IFERROR(VLOOKUP(A2,'Sheet1'!A:B,2,0),"")

Wil1969

Hi Minhokiller,
 thanks for your effort. The translation didn't understand that I wanna have a complete row colored in reference to to values of certain cells.
 Best reguards
 Wil
 P.s.: Ich weiß, Deutsches Forum.

Lisa Wilke-Thissen

Hi,

not a bug, but a feature ;-) of all versions of Word.

Viele Grüße

Lisa

Hi,

willkommen im Windows Forum!

Sum of unique/distinct values of a filtered column - Similar Threads - Sum unique distinct	Forum	Datum
Account blocked all of a sudden! Account blocked all of a sudden!: Aus diesem Thread ausgliedern. Guten Tag,ich befinde mich am Rande der Verzweiflung. Mein Account wurde ebenfalls aus heiterem Himmel gesperrt.Ich habe das selbe Problem. ich benutze seit so...	Outlook.com	1. Oktober 2022
Checking availability of a large amount of applications in Microsoft store Checking availability of a large amount of applications in Microsoft store: My goal is to check for around 800 tools whether they are available in the Microsoft Store or not. Is there a way to query the tools available in the Microsoft Store via API or something similar?...	Apps	9. April 2021
March of Empires War of Lords March of Empires War of Lords: Ich habe die Frage ,ein Mitspieler von mir Dark Dragon musste sein Rechner neu installieren und kommt nicht in seinen alten Account. Was muss er machen das er wieder rein kommt im Spiel War of Lords	Apps	8. November 2019
March of Empires War of Lords March of Empires War of Lords: hallo Community ich musten mein PC neu aufsetzen und habe das spiel March of Empires War of Lords neu instaliert ! jetzt die frage wie bekomme ich mein altes konto wieder ? Vielen...	Apps	1. November 2019
Age of Empire War of Lords Age of Empire War of Lords: Hallo, Kann mein March of Empire War of Lords auf dem PC nicht mehr öffnen, nachdem ich March of Empire War of Lords vom Ipad auf den PC übertragen habe. kann nur noch den gleichen Account wie...	Apps	10. August 2019
How can I include another set of data, w.g. a line for a fixed limit or a growing sum in a... How can I include another set of data, w.g. a line for a fixed limit or a growing sum in a...: [IMG]or [IMG] THank you	Microsoft Office	24. Juli 2019
getting rid of large number of duplicates of contacts getting rid of large number of duplicates of contacts: For some time now some of my contacts are shown uncountable times in a row. Trying to delete them one by one seems to not really work or makes the People app crash after some time. Also it makes...	Outlook.com	27. September 2017

Sum of unique/distinct values of a filtered column

Sum of unique/distinct values of a filtered column

SQL in Access VBA

VlookUp in VBA

Help with sverweis/Vlookup function

Wenn-dann-Regel mit Prioritäten erstellen (Excel)

BUG: Headers in Tables do not appear in Navigation bar

User Advert

Sum of unique/distinct values of a filtered column - Microsoft Office

Sum of unique/distinct values of a filtered column - Similar Threads - Sum unique distinct

Account blocked all of a sudden!

Checking availability of a large amount of applications in Microsoft store

March of Empires War of Lords

March of Empires War of Lords

Age of Empire War of Lords

How can I include another set of data, w.g. a line for a fixed limit or a growing sum in a...

getting rid of large number of duplicates of contacts

Sum of unique/distinct values of a filtered column solved