如何使用多个参数过滤数据 [英] How to Filter Data with Multiple Parameters
问题描述
我想根据当天和用户名来统计一系列数据。数据正在从查询中提供,而且我不希望使用数据透视表,因为我想将数据归档到我从商店中提取数据的程序之外。以下是我收集的数据示例。
我想对列D进行计数 FULL_PLLT_QTY,但仅在G列SHIFT_DT和列I名称中的日期。
EX。我想对史密斯R.W。6/27/1010的D列进行统计。
有没有办法为大范围的日期和名字做这个?此外,名称显示在多个日期。任何帮助,将非常感谢!
= SUMIFS(D:D,G:G ,6/7/2017 0:00,I:I,Smith,RW)
匹配日期条件将取决于关于列G的确切格式。以上假设它只是一个字符串。如果ti是日期,那么您可能需要使用 = DATE(2017,7,6)
而不是文字字符串6/7/2017 0:00。 / p>
I'd like to tally a series of data based on the day and user name. The data is being fed from a query, and I am not looking to use a pivot table because I would like to archive the data past what the program I am pulling the data from stores. Below is a sample of the data I have collected.
I want to tally the Column D "FULL_PLLT_QTY", but only for the date in Column G "SHIFT_DT" and the Column I "Name".
EX. I want to tally Column D for 6/7/2107 for Smith, R.W.
Is there a way to do this for a large range of dates and names? Also, the names appear on multiple dates. Any help with this would be much appreciated!
=SUMIFS(D:D,G:G,"6/7/2017 0:00",I:I,"Smith, R.W.")
Matching the date condition will depend on the exact format of column G. The above assumes it is just a string. If ti is a date then you probably need to use =DATE(2017,7,6)
instead of the literal string "6/7/2017 0:00".
这篇关于如何使用多个参数过滤数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!