资讯

These aren't your basic SUM and AVERAGE formulas ... and ZIP code into separate columns. You can add =TEXTBEFORE(A1, ","), ...
Nick David / Getty Images There is no specific formula in Excel or other spreadsheet ... weight in the next one, column Y. Use the formula =SUMPRODUCT(X1:X10, Y1:Y10)/SUM(Y1:Y10) to calculate ...