Ubuntu
openoffice.org package

calc equivalant of =averageif(N5:N16,">0")

Asked by maestro

calc has no averageif function. Does anyone know how to duplicate this excel function?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
maestro (maestro49m) said : 		#1

I tried changing the cells N5:N16 to if(existing function;existing function;"") and using average(N5:N16).
This seems to work. You would have to get more creative for something other than ">0".

Revision history for this message
pe3k (qyx) said : 		#2

Hi,
maybe check "DAVERAGE" function in help:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DAVERAGE_function

I think it will do your job.

Can you help with this problem?

Provide an answer of your own, or ask maestro for more information if necessary.

To post a message you must log in.