On one tab, I have a list of the names of my employees. On another tab, I have orders that my employees have shipped, together with the month they shipped them, going back a full year. To get the average quantity of products supplied per employee each month, I must first know how long they have worked for the company. Therefore, I want to create a formula that basically says, "Give me the count of the specific amount of months they've been shipping things."

Sample employee data:

And here's the sample data on the individual shipments:

So in order to determine that Joe Smith ships an average of 83.3 items per month, I need to know that he sent those 250 products over the course of three separate months. Again, I can't just divide them all by 12 and need to know how many months they were shipping products because there were so many new hires in the past 12 months.

Feb 10, 2023 in Others 339 views

## 1 answer to this question.

FILTER Shipper and Month based on Employee name in the Shipper column. To obtain just unique data (name + month number), apply UNIQUE to the filtered array. To calculate active months, use COUNT. Distribute the Products Sent by it.

Result:

• 63,700 points

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

## Determine if calculation between 2 date time values is < 72 Hours in excel

Actually, Excel is quite accommodating in this ...READ MORE

## Count cells in excel with populated values

Use: =SUMPRODUCT(--(CHOOSE({1,2,3,4,5},A1, A4, A6, A8, A10)<> ...READ MORE

## How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

## Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

## Excel Formula Query on Summing Annual Leave Days and Half Days

Try Something like =SUM(COUNTIF(\$A\$1:\$A\$8,"A"),COUNTIF(\$A\$1:\$A\$8,"HA")/2) - total count ...READ MORE

## How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

## Newbie needs Excel suggestions with a simple script

Formula to Count the Number of Occurrences ...READ MORE