Forum Discussion
Seanm1525
Jan 04, 2021Copper Contributor
averageif help
I am having trouble with the averageif function on Excel. What I'm doing is trying to get the average postsecondary years of students who have been elected. The postsecondary years and the elected co...
Seanm1525
Jan 05, 2021Copper Contributor
Thank you, JoeUser2004! I didn't realize I had put averageifs instead of averageif. That was a typo. I'll try your suggestion on the iferror.
SergeiBaklan
Jan 05, 2021Diamond Contributor
As JoeUser2004 mentioned you may use both, just order of parameters will be different.