Re: [libreoffice-users] Calc Function

In LO 4.1 the COUNTIF Function has only two params: range and criteria.

Gerald

On 2014-01-11 19:17, James E Lang wrote:
> Please fill in the blank ("___") below with a function name or tell me there is no such function:
>
> SUM(range) is to SUMIF(range1,criteria,range2) as COUNT(range) is to ___(range1,criteria,range2)
>
> COUNTIF would seem to be the logical answer but I don't think it supports the third parameter and 
> thus it is not analogous to COUNT.
>
> I'm wanting to use it as follows:
>
> =IF(___(A$3:A7,A7,Q$3:Q7)=___(A$3:A7,A7,R$3:R7),SUM(A$3:A7,A7,R$3:R7)-SUM(A$3:A7,A7,Q$3:Q7),"Error 
> 4")
>
> Where Error 4 means that the start miles in Q$3:Q7 and end miles in R$3:R7 are not properly paired 
> and thus the miles driven on date A7 cannot be determined.
>
> I realize that I can add two columns (e.g. AA and AB) such that the content of their cells 
> (AA$3:AA7 and AB$3:AB7) is 1 if the corresponding cell in column Q or R respectively contains a 
> number (otherwise it's a zero length string). Then I could use SUMIF(…,AA$3:AA7)=SUMIF(…,AB$3:AB7) 
> as the condition within the IF(condition,true,false) construct in my formula.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted