Excel中的automatic_count_value [英] automated_count_value in excel

问题描述

#CLAIMS CLAIM TYPE
2 HCFA
5 HCFA
2 MISC
5 DEN
3 MISC
4 UB
6 HCFA
4 HCFA
1 DEN
5 UB
6 HCFA
2 MISC
1 MISC

MISC HCFA UB DEN发票总计
0 0 0 0 0 0

亲爱的所有人，
我需要自动逻辑才能计数.根据气候类型分类的索赔.
由于最初我在第二张表中给出的所有记录均为零，由于没有任何屏幕截图工具，因此我不得不像这样粘贴我的查询，现在我必须手动计算否. HCFA'S索赔，MISC'S索赔等.因此，应该使用什么逻辑对这些记录进行计数.


感谢和问候，
ravindra bisht

# CLAIMS CLAIM TYPE
2 HCFA
5 HCFA
2 MISC
5 DEN
3 MISC
4 UB
6 HCFA
4 HCFA
1 DEN
5 UB
6 HCFA
2 MISC
1 MISC

MISC HCFA UB DEN INVOICE TOTAL
0 0 0 0 0 0

Dear All,
I need automated logic for count no. of claims on the basis of their cliam type.
Since intitally I''ve given all the records in second sheet is zero.Since there is no any screen shot facility so I''m having to just paste my query like this.Now I have to manually count no. of HCFA''S claims,MISC''S claims and so on.So what logic should be used to count these record.


thanks and regards,,
ravindra bisht

推荐答案

尝试使用SUMIF表达式来计算所需的数据.例如，

Try to use SUMIF expression to calculate data required. For example,

SUMIF(Sheet2!B2:Sheet2!B15;"=HCFA";Sheet2!A2:Sheet2!A15)

这篇关于Excel中的automatic_count_value的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！