Functions in OpenOffice

[Bob McElmurry]

Currently I am using Microsoft Office 2010 and am working in a small school.  I 
would like to use OpenOffice or LibreOffice but I have not found some of the 
functions that I like such as countifs, sumifs, and averageifs.  Because of 
using these functions, I do not feel that it would be an asset to change to 
OpenOffice.  Any suggestions?
Bob