Log In
Register
Home
Active Member
July 12, 2024
Offline
I need the average of certain data in a column, but not all the data. See the attached spreadsheet for explanation.
Thank you in advance for your assistance.
Vicki
October 5, 2010
Offline
Nothing attached.
Click Start Upload after selecting the file
Trusted Members
October 17, 2018
Offline
I also suggest you tell us the Excel version you're using
Active Member
July 12, 2024
Offline
I apologize, I did not get the file attached. Thanks for the reminder Phil.
The attached in written with Office 365, Excel v2404, but I need it to work in Excel 2016.
Active Member
July 12, 2024
Offline
If you filter the Discount Factor in "Averageifs - multiple conditions II.xlsx" to only PR and T1, it will be easier to see the data for each ticket.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
In your sample data you have no T1 discount factor below 12, that is why you get the #DIV/0! error. You can use IF or IFERROR to handle such scenarios.
Br,
Anders
Active Member
July 12, 2024
Offline
PR is the factor that should be <> 12. The T1 is averaged.
This has been solved on another site. Thanks to everyone. Vicki
July 16, 2010
Offline
Hi Vicki,
Thanks for following up, however in future when you cross post you should declare that up front so volunteers know that they could be wasting their time if the question has been asked and answered elsewhere. This is forum etiquette no matter what forum you post on.
Thanks,
Mynda
1 Guest(s)
