在EXCEL中如何使用vlookup在多列中查找引用?答:=SUMIF(Sheet1!A1:E6,A2,Sheet1!B1:F6)2、如果B、D、F列不是数值,而是文本。VLOOKUP查询可以进行判断:=IF(COUNTIF(Sheet1!A:A,A2),VLOOKUP(A2,Sheet1!A:B,2,0),IF(COUNTIF(Sheet1!C:C,A2),VLOOKUP(A2,Sheet1!C:D,2,0),IF(COUNTIF(Sheet1!E:E,A2),VLOOKUP(A2,Sheet1!E:F...