请问高手:excel中,如何把countif、表间取数结合使用?答:),IF(A1=60,COUNTIF(表4!B:B,">=60")-COUNTIF(表4!B:B,">=85"),"")))A5=IF(A1=90,COUNTIF(表5!B:B,">=90"),IF(A1=85,COUNTIF(表5!B:B,">=85")-COUNTIF(表5!B:B,">=90"),IF(A1=60,COUNTIF(表5!B:B,">=60")-COUNTIF(表5!B:B,">=85"),"")))...
EXCEL中,IF和COUNTIF能否同时使用,比如:C3=IF(Sheet1!B:B=B3,(COUNT...答:C3中的公式 =COUNTIFS(Sheet1!A:A,1,Sheet1!B:B,B3)D3中的公式 =SUMIFS(Sheet1!C:C,Sheet1!A:A,1,Sheet1!B:B,B3)