Excel Sumif criteria in one of several columns is met

BingoKT · 28. August 2023

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 respective input i.e. Connection type "X" in this example. If am a bit stuck with sumifs and lookup formulas and I think/hope there should be a relatively easy way to do this. Many thanks in advance!

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),"")

KLaus Henrichs

Thanks, Thomas for the quick reaction
I did what you recommended. Now, the de-installation of Office is running since more than one hour. Is this normal?

offoffice

It even works for several paragraphs within one textbox if I use a different slide master.

NikolinoDE

Yes, it is possible to create dynamic filters for a SharePoint list view that will automatically update the calendar view to show only the items that meet the filter criteria. You can do this by using the Filter option in the list view settings.
To create a dynamic filter for your list view, follow these steps:

Open the list in SharePoint and switch to the view you want to filter.
Click on the gear icon in the top right corner of the page and select “List settings” from the drop-down menu.
Scroll down to the “Views” section and click on the name of the view you want to filter.
In the “Filter” section, select “Show items only when the following is true” and set up your filter criteria using the available fields and operators.
Click “OK” to save your changes.

Once you’ve set up your dynamic filter, the calendar view will automatically update to show only the items that meet your filter criteria. You can change or remove the filter at any time by going back to the list view settings and modifying your filter criteria.

Pauline R.

Hallo Andreas,

Excel für Windows und Excel für Mac sind nicht identisch, die Spaltenbreiten der beiden Programme sind von Haus aus verschieden und es werden verschiedene Einheiten für die Berechnung der Spaltenbreite verwendet.

Die Spaltenbreite in Excel für Windows ist abhängig von der Standardschriftart. Wenn du als Standardschriftart Calibri 11 verwendest und eine Spaltenbreite von 10 hast, heißt das, in eine Zelle passen 10 Zeichen der Schriftart Calibri 11. Eine Änderung der
Standardschriftart ändert auch die Breite der Spalten.

Eine Spaltenbreite von z.B. 10 in Excel für Windows entspricht
nicht einer Spaltenbreite von 10 in Excel für Mac. Du musst daher die Spaltenbreite umrechnen und auf dem Mac anpassen. Achte auch darauf, dass du in Excel für Windows eine Schriftart eingestellt hast, die es auch auf dem Mac gibt.

Eventuell hilft dir dieser Artikel:
http://excelsemipro.com/2010/10/column-width-unit-of-measure-in-excel-versions/

Gruß,

Pauline

Hi,

willkommen im Windows Forum!

Excel Sumif criteria in one of several columns is met - Similar Threads - Excel Sumif criteria	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
several Errorcodes several Errorcodes: Hey there,since April this year, I had to completely renew my PC with hardware because my old maindrive crashed and my brother installed Windows 11, it is activated, but since having it installed,...	Apps	5. Juni 2023
several Errorcodes several Errorcodes: Hey there,since April this year, I had to completely renew my PC with hardware because my old maindrive crashed and my brother installed Windows 11, it is activated, but since having it installed,...	Games und Spiele	5. Juni 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
Sum of unique/distinct values of a filtered column Sum of unique/distinct values of a filtered column: 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...	Microsoft Office	27. Januar 2023
Excel for iPad - moving of cells, rows or columns does no longer work Excel for iPad - moving of cells, rows or columns does no longer work: Hello - Suddenly I cannot move cells, rows or columns in Excel for iPad anymore. Usually, I just select the cell, row or column and then drag & drop them to another locationn in the Excel...	Microsoft Office	22. November 2020
One of your Folders is named incorrectly One of your Folders is named incorrectly: Wie kann ich das ändern? Danke für die Antwort	Outlook.com	24. März 2019

Excel Sumif criteria in one of several columns is met

Excel Sumif criteria in one of several columns is met

Help with sverweis/Vlookup function

Umstieg Microsoft 365 Business auf Microsoft 365 Family

PPT animate by paragraph not working

Dynamic Filter

Anzeige Unterschied zwischen Excel Win und Excel Mac

User Advert

Excel Sumif criteria in one of several columns is met - Microsoft Office

Excel Sumif criteria in one of several columns is met - Similar Threads - Excel Sumif criteria

Get the data part of a stuctured column in VBA

several Errorcodes

several Errorcodes

Inheritance of values from columns in the library

Sum of unique/distinct values of a filtered column

Excel for iPad - moving of cells, rows or columns does no longer work

One of your Folders is named incorrectly

Excel Sumif criteria in one of several columns is met solved