SUMIF仅过滤数据 [英] SUMIF only filtered data

问题描述

我有一个Excel公式，可以对特定数据列求和.

I have an excel formula that sums a particular column of data.

SUMIF(Data!$E:$E,$E$89,Data!$F:$F)

我想添加一个我想过滤的G列.因此，理想情况下，当我单击数据"->过滤器"时，我可以使SUMIF只求和我在G列中过滤的所有内容.

I'm looking to add a column G which I want to filter over. So, ideally, when I click Data->Filter, I can make SUMIF only sum whatever I filter in column G.

是否有这样做的好方法?

Is there a good way of doing so?

数据看起来像这样:

E     F         G
111   20050719  Foreign
112   20050719  Domestic
576   20050719  Foreign
624   19910101  Domestic

$E$89 = 20050719

推荐答案

所需的公式已从本文中获取并修改； CountIf包含过滤数据

The formula you want is taken and modified from this post; CountIf With Filtered Data

=SUMPRODUCT(SUBTOTAL(9,OFFSET(E2:E7,ROW($F$2:$F$7)-MIN(ROW($F$2:$F$7)),,1)),(E89=$F$2:$F$7)+0)

这篇关于SUMIF仅过滤数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！