
julie vandermeulen
Member
Members

Forum Posts: 15
Member Since:
November 8, 2018
November 8, 2018

I have been trying to get an average formula to work and not matter what I try it doesn't.
=AVERAGE(H335+H323+H311+H299+H287+H275+H263+H251+H239+H227+H215+H203+H191+H179+H167+H155+H143+H131+H119+H107+H95+H83+H71+H59+H47+H35+H23+H11)
(The cells listed have formulas in them)
I do not want to include zeros or blanks in the average but no matter what I try it either includes zeros in the count or I get an error.

SunnyKow
Puchong, Malaysia
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016


Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 871
Member Since:
December 7, 2016
December 7, 2016

Hello Julie,
As Sunny shows very well in his example, you can use AVERAGEIF(S) to avoid zeros. Not sure if you have checked this article, if not then it might help you with this. https://www.myonlinetraininghu.....averageifs
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Denise Lloyd
Guest(s) 10
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Raj Mattoo
Mark Luke
terimeri dooriyan
Jack Aston
AndyC
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6219
Posts: 27276
Member Stats:
Guest Posters: 49
Members: 31903
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
