在EXCEL内设设公式

发布网友 发布时间：2022-04-24 03:34

我来回答

共3个回答

热心网友 时间：2023-10-25 05:27

=IF(COUNTIF(A5:A100,"福瑞迪")>0,COUNTIF(B5:B100,"福瑞迪"),"")

热心网友 时间：2023-10-25 05:27

=IF(ISERROR(MATCH("福瑞迪",A5:A100,0)),"没发现",COUNTIF(B5:B100,"福瑞迪"))

热心网友 时间：2023-10-25 05:28

=SUMPRODUCT（（A5：A100="福瑞迪")*（B5：B100="福现迪"))

热心网友 时间：2023-10-25 05:27

=IF(COUNTIF(A5:A100,"福瑞迪")>0,COUNTIF(B5:B100,"福瑞迪"),"")

热心网友 时间：2023-10-25 05:27

=IF(ISERROR(MATCH("福瑞迪",A5:A100,0)),"没发现",COUNTIF(B5:B100,"福瑞迪"))

热心网友 时间：2023-10-25 05:28

=SUMPRODUCT（（A5：A100="福瑞迪")*（B5：B100="福现迪"))