tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I think this might be a little more complex that it sounds so I'll try explain all my problems and what i need.
I want a formula that can give me the ave of the last 4 sales of one item.
So in Sheets "Ave" Column D i have a list of SKU's so lets say i'm looking at row 4 for now,
So cell "D4" gives me the SKU "XYZ123"
Now in Sheet "Invoice" Column C are all my Sku's for each sale and in Column G the dates,
So I need to find the last 4 sales add then up and give me the average, however some might not have 4 sales in which case add up as many as there are, if theres none say "No Sales"
Please help if you can
Thanks
Tony
I think this might be a little more complex that it sounds so I'll try explain all my problems and what i need.
I want a formula that can give me the ave of the last 4 sales of one item.
So in Sheets "Ave" Column D i have a list of SKU's so lets say i'm looking at row 4 for now,
So cell "D4" gives me the SKU "XYZ123"
Now in Sheet "Invoice" Column C are all my Sku's for each sale and in Column G the dates,
So I need to find the last 4 sales add then up and give me the average, however some might not have 4 sales in which case add up as many as there are, if theres none say "No Sales"
Please help if you can
Thanks
Tony