Listed in Range A1:C13 are the totals of sales made by each salesman per date.
A blank cell in column E, indicates that no sales were made by that salesman on that date.
How could we calculate the averaged total of sales per each date and per each salesman, disregarding blank cells?
Using the AVERAGE and IF functions in an Array Formula, such as this:
(To create Array formula: select the cell after typing the formula,press F2 and then press Ctrl+Shift+Enter)
Date___________ Salesman ID_____Total Sales
Date___________Salesman ID______Averaged Sales
Screenshot // Disregarding blank cells when performing calculations on a range.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.