Posted to microsoft.public.excel.misc

external usenet poster

Posts: 12

Conditional Average with Multiple Columns

Hello Excel Gurus !

In Sheet1, I have 13 columns total (A=Location, B - M are Months)

A B C D E F
Location Jan Feb Mar May Jun
Hawaii 5 8 12 22 45
Denver 10 58 41 44 10
Portland 12 58 77 88 99

In Sheet2, A1, A2 and A3 are manual input of months

A B C
Feb Mar

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Conditional Result based on Multiple Columns	AnnArborBrian	Excel Worksheet Functions	6	May 10th 08 02:29 PM
Conditional AVERAGE?	Leonhardtk	Excel Worksheet Functions	7	September 19th 07 10:31 PM
How do I apply conditional formulas across multiple columns?	ansoriano1	Excel Worksheet Functions	2	August 25th 06 04:49 PM
How do I get an average sale if multiple columns?	Todd	Excel Worksheet Functions	9	July 27th 06 09:07 PM
Conditional count of rows dependent on multiple columns	Edwin Castro	Excel Worksheet Functions	1	January 11th 06 12:16 AM

All times are GMT +1. The time now is 08:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us