Good afternoon! Been a user a OpenOffice for a little over a year now and I try to use it as much as I can. I talk about it with anyone who asks what I recommend as up until today, everything that I have been able to do in Excel, I could do in Calc. Today, I came across something that I would like to suggest, integrating the COUNTIFS feature into a future version of Calc.
COUNTIFS is like nested COUNTIF statements. Counting an occurance based on more than one criteria. For a spreadsheet I'm working on this is very important. I know there are workarounds for but since this spreadsheet will be maintained by others, I need to make it simple. The COUNTIFS statement does that. Also, one feature that Excel has that I really would like to see if future versions of Calc is the ability for Calc to show Average: Count: and Sum: at the bottom of the screen, similar to what Excel does. I know that you can right click on the bottom portion and alternate between Average, CountA, Count, Maximum, Minimum, Sum and None. It is very beneficial to have all three together, shown at the same time. There appears to be enough room at the bottom to accommodate this. If there is a way to do it, please let me know. Again, really love using OpenOffice. I use it exclusively at home, got my parents and my bother using it and until now, have been able to find a reason that I had to use Excel. If COUNTIFS was added to a future version, I could go back to exclusively using it again. Thank you, --Glenn [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
