On 04/13/10 21:48, Glenn M. Reed wrote:
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.
We have an open enhancement issue for COUNTIFS (http://www.openoffice.org/issues/show_bug.cgi?id=90269). But an equivalent formula with SUMPRODUCT really isn't much more complicated, see http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
