ExcelNovice2020
Member
Members
Forum Posts: 68
Member Since:
February 8, 2020
February 8, 2020
Offline
If appending several pieces of data and then grouping rows, how do you exclude cells with zero (0) from the AVERAGE operation? I've tried replacing the 0 with null but they are still factoring in with the average.
For example, if the data is 10, 20, 0, grouped and averaged should be 15, not 10.
Or, would it be best simply to use MEDIAN instead of AVERAGE?
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Riny van Eekelen, Riaan van Zyl
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ed Norris
manoj Ka
Chris Cowan
Pawel Ganczarski
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Ben Tooke
Kelsey Fennell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30126
Member Stats:
Guest Posters: 49
Members: 33676
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —