Hello! Hope someone can help me with my remaining problem. I have 3 questions that needs to be answered using my raw data (also attached) Order date Product number Customer ID Order Count Order Value 2/21/2021 1A A1 1 0 2/21/2020 1A A2 1 15.7 11/16/2020 1A A3 1 37.2 2/22/2021 1B A3 1 44.6 9/5/2020 5657 A4 2 78.6 1/17/2021 78787 A5 1 32.5 12/3/2020 878 A6 1 67.7 12/10/2020 878787 A6 1 89.1 2/13/2021 8787877 A6 1 1 2/17/2021 8787878 A6 2 90.1 2/17/2021 787878 A6 2 130 1. First problem, i need to get the average days between orders for customers with more than 2 orders. 2. 2nd, to derive the average number of products per customer order. 3. 3rd, to derive the average number of ordered unique products. I was able to get this using pivot table but i wanted to know how to derive this using formula of AverageIfs or sumproduct Thank you.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

average or sumproduct?

Thread starter excelnewbie26
Start date Oct 25, 2023

excelnewbie26

New Member

Oct 25, 2023

Hello!

Hope someone can help me with my remaining problem. I have 3 questions that needs to be answered using my raw data (also attached)

Order date	Product number	Customer ID	Order Count	Order Value
2/21/2021	1A	A1	1	0
2/21/2020	1A	A2	1	15.7
11/16/2020	1A	A3	1	37.2
2/22/2021	1B	A3	1	44.6
9/5/2020	5657	A4	2	78.6
1/17/2021	78787	A5	1	32.5
12/3/2020	878	A6	1	67.7
12/10/2020	878787	A6	1	89.1
2/13/2021	8787877	A6	1	1
2/17/2021	8787878	A6	2	90.1
2/17/2021	787878	A6	2	130

1. First problem, i need to get the average days between orders for customers with more than 2 orders.
2. 2nd, to derive the average number of products per customer order.
3. 3rd, to derive the average number of ordered unique products.

I was able to get this using pivot table but i wanted to know how to derive this using formula of AverageIfs or sumproduct

Thank you.