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
Get the data part of a stuctured column in VBA Get the data part of a stuctured column in VBA: This will get me a column of data from a structred tableFunction GetNameColumn As Range Dim ws As Worksheet Dim tbl As ListObject Dim colName As ListColumn Set ws = SheetsSheetName Set tbl =...	Microsoft Office	17. Oktober 2024
update the values of an empty lookup column in Microsoft lists/sharepoint with the values... update the values of an empty lookup column in Microsoft lists/sharepoint with the values...: There are two lists List A and List B in Sharepoint.Both lists each have a column column TP that largely matches. The list has another lookup column. This lookup column is to be filled with the...	Microsoft Office	9. Februar 2024
Excel Sumif criteria in one of several columns is met Excel Sumif criteria in one of several columns is met: TypeLengthConnection 1Connection 2Connection 3A5XYZB10XYCC15HUXHi All, I would like to calculate the total sum of column B / Length if any of the other columns Connection 1,2 or 3 matches a...	Microsoft Office	28. August 2023
Excel Automate - get highest number in filtered Column Excel Automate - get highest number in filtered Column: Hello, I want to get the highest number via an automate script in excel in a filtered Column.I had only find out how to get a specific Cell Value "selectedSheet.getRange"M28""But how can i store...	Microsoft Office	19. April 2023
Inheritance of values from columns in the library Inheritance of values from columns in the library: Hi all, I have the following problem. I have a SharePoint library with over 10,000 folders. I have already built the term store for it. How is it now possible that the values in the columns of the...	Microsoft Office	4. April 2023
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
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

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

Get the data part of a stuctured column in VBA

update the values of an empty lookup column in Microsoft lists/sharepoint with the values...

Excel Sumif criteria in one of several columns is met

Excel Automate - get highest number in filtered Column

Inheritance of values from columns in the library

Checking availability of a large amount of applications in Microsoft store

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

Sum of unique/distinct values of a filtered column solved