excel
In
excel, it is common practice to use English notation for formulas. If you are using
excel 2007 or later, you can simply enter the formula =SUMIFS(F1:F100,A1:A100,"张三",F1:F100,">0") to get the data of Zhang San.If you are using
excel 2003, the formula would be =SUM((A1:A100="张三"(F1:F100>0)*F1:F100). It is important to note that you need to press Ctrl+Shift+Enter while entering this formula.Alternatively, you can use the formula =SUMPRODUCT((A1:A100="张三"(F1:F100>0)*F1:F100) as another option.Please keep these in mind when working with
excel formulas.
