[libreoffice-users] Calc cross-sheet issue with COUNTIF and AVERAGEIF...

[Ryan Ashley]

I have developed a spreadsheet which contains a sheet for the cover and 
basic information as well as one sheet for every month. There is a cell 
with a number on every sheet at location H35. I want the average of all 
of those which are not zero on the first sheet. I initially tried using 
"AVERAGEIF(January.H35:December.H35, ">0")", but it keeps giving me 
error 504. I then tried the formula below, which uses COUNTIF, but the 
part with COUNTIF in it causes a 504 also. If I cannot use COUNTIF or 
AVERAGEIF, how do I get an average of cell H35 on each sheet where H35 
is greater than zero?

--
To unsubscribe e-mail to: users+unsubscr...@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