Irish Forums Message Discussion :: Excel spreadsheet formulas

irelandIrish Forums :: The Irish Message Forums Irish Communityireland
Irish Forums :: The Irish Message
Forums About Ireland and the Irish Community, For the Irish home and Abroad. Forums include- Irish Music, Irish History, The Irish Diaspora, Irish Culture, Irish Sports, Astrology, Mystic, Irish Ancestry, Genealogy, Irish Travel, Irish Reunited and Craic

Search Irish Websitesireland
Irish Forums Bookmark The Irish Community Forums

Excel spreadsheet formulas

       Excel spreadsheet formulas Excel spreadsheet formulas Information
Post New Irish Message Discussion In Sceala Irish Craic Forum    Reply To Irish Community Message About Excel spreadsheet formulas In Sceala Irish Craic Forum
Irish Forums :: The Irish Message Forums- Sceala Irish Craic Forum- Excel spreadsheet formulas
Irish Author Excel spreadsheet formulas Sceala Irish Craic Forum Irish Message
kerrin

Sceala Clann T.D.
Location: Wicklow






Sceala Irish Craic Forum Discussion:     Excel spreadsheet formulas

A long shot.
Would anyone know the formula to exclude zero in an array ... within excel spreadsheets.
I can obtain the average from a set ....but I also require a running total average ...excluding zero's.
I searched this promising answer on google
......
Creating Array Formulas Using Arrays Of Data....
The IF function can be used in an array formula to test the result of multiple cell tests at one time. For example, you may want to compute the average of the values in A1:A5 but exclude numbers that are less than or equal to zero. For this, you would use an array formula with an IF function to test the cell values and an AVERAGE function to aggregate the result. The following formula does exactly this:
=AVERAGE(IF(A1:A5>0,A1:A5,FALSE))
.........
I have tried this ....results in a name error?

Forum Message Irish Topic Alert

The Irish Community have posted
11 REPLIES TO THIS TOPIC
for logged in members to view.
Back to top  Login here and be redirected to this TopicLogin here and be redirected to this Topic RegisterRegister

    Post New Irish Community Message In Sceala Irish Craic Forum    Reply To Irish Community Message About Excel spreadsheet formulas In Sceala Irish Craic Forum    Irish Forums :: The Irish Message Forums -> Sceala Irish Craic Forum
Page 1 of 1
If Seeking Information About Excel spreadsheet formulas, Try Searching Irish Websites

Related Irish Topics
When was British first used invented
Sham Marriages and immigrants Islamic lunatics using Ireland
Black Irish
SAAB owners Ireland new and used parts.
Ulster name unchanged team
Excel spreadsheet formulas
Log in
Username:
Password:




SearchSearch
FAQFAQ

Search For Irish Websites
general Irish Websites search for information about Ireland and the Irish
Irish Websites

Research Irish Ancestors
Specific Irish heritage search engine, search for your Irish family surname roots, find out if your family have a Irish clan organisation.
Irish Websites
Irish Weather
Ireland Weather
Weather in Ireland
Ireland Weather forecast