The SUMIFS function works in a similar way with text as with numbers, but there are two key differences. First, text in Excel ...
To calculate your average trade price, add all purchase prices and divide by the number of trades. Use weighted average trade price calculation if share quantities vary per purchase. Weighted averages ...