Posted to microsoft.public.excel.newusers

Mellybean

external usenet poster

Posts: 3

Adding the value of cells than 4.5

I am working with a sheet containing numbers in cells between 1-6, I only
need the numbers 4.5 or greater, and average those numbers. what is the
formula for it to determine say cells A1:A30 only the ones 4.5 + the average

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help w/ adding cells and dividing SUM by number of cells	lnbegin	Excel Worksheet Functions	4	September 26th 07 04:26 PM
ADDING CELLS	Scott	Excel Discussion (Misc queries)	1	March 15th 07 05:37 PM
Adding cells	Daniel	Excel Discussion (Misc queries)	1	April 9th 06 11:57 PM
Adding Cells	Kyle Sweeney	Excel Worksheet Functions	4	September 15th 05 10:36 AM
Adding colour to a range of cells based on one of the cells v...	McKenna	Excel Discussion (Misc queries)	4	March 11th 05 02:25 PM

All times are GMT +1. The time now is 11:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us