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.