calculation a average dependated of values in seperate column

Posted to microsoft.public.excel.worksheet.functions

vinnie123

Posts: n/a

calculation a average dependated of values in seperate column

Hi everyone. I've a spreadsheet with one column (eg. A1:a100)
containing a range of values (ages) and another column (B1:100) a value
of either 1 or 2 (representing males vs females).

How can a find the average of the cells A1:A100 that have a value of 1
in column B; ie. the average age of the males only.

Thanks

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 to Improve Code Copying/Pasting Between Workbooks	David	Excel Discussion (Misc queries)	1	January 6th 06 03:56 AM
How can I average certain number of lowest values in a column?	Philcw	New Users to Excel	1	September 13th 05 05:58 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Excel Worksheet Functions	9	July 31st 05 03:37 AM
How to average a column, but exclude zero AND negative values?	KMHarpe	Excel Discussion (Misc queries)	1	July 20th 05 10:06 PM
Return Count for LAST NonBlank Cell in each Row	Sam via OfficeKB.com	Excel Worksheet Functions	12	April 17th 05 10:36 PM

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

Menu

About Us