aaronpawlak
Novice

Average function doesn't work?

Hello,

 

This is probably going to be a pretty simple answer for the seasoned members of the board, I did search but after reading through a few posts didn't find what I was looking for.There's no averageif function for OpenOffice, but is there something similar? .For some reason using the normal average function doesn't work for me. I input the data into colums k2 to k31. If I put them all as ones, the average for some reason comes out as 1.9.Any reason for this? .Any tips and Case study example would be greatly appreciated.Please help me out.

 

Any help will be appreciated.
Thank you.

0 Kudos
Reply
2 Replies
boringNerd1
Apprentice

Re: Average function doesn't work?

Hi,


 


I'm a little confused here. Are you talking about implementing something similar in OpenOffice, or K2?

0 Kudos
Reply
Not applicable

Re: Average function doesn't work?

Hello Aaron,


 


Please see the link below, perhaps it might help you get the averageif function to work:


https://help.libreoffice.org/Calc/AVERAGEIF_function


 


Kind Regards,


Sello

0 Kudos
Reply