Microsoft Excel Use Comma Separated List as OR Criteria in SUMIFS Function
Автор: Priority Thinking, LLC
Загружено: 2023-02-06
Просмотров: 1237
In this tutorial, we will use the FILTERXML function to convert comma-separated values (CSV) to an array constant which can be used as OR logic in the criteria parameter of a SUMIFS or COUNTIFS function.
The use case of the example document is that data is provided as a comma-separated a string that we would like to use as an OR criteria in a SUMIFS function.
This tutorial was recorded on Windows 10 Pro using Microsoft Excel Version 2301 Build 16.0.
0:00 - Explanation of Problem
3:15 - Solution
5:10 - Calculation Verification
Dynamic Arrays Using FILTERXML: / append-arrays-in-excel-using-filterxml
Array Constants: https://support.microsoft.com/en-us/o...
For Excel consulting, please contact us at:
https://www.prioritythinking.com
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: