Posted to microsoft.public.excel.misc

blackstar

Posts: n/a

average calculation

using the formula below i've been able to get the sum of column B if the
corresponding cell in column A says "spring". my question is
how can i do the same thing but to get the AVERAGE instead of the SUM.

=SUMPRODUCT(--(A2:A14="spring"),(B2:B14))

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
Average Calculation	smallcap	Excel Worksheet Functions	6	October 28th 05 12:36 AM
Conditional reference on average interest calculation	PiPPo	Excel Worksheet Functions	1	October 21st 05 07:28 PM
How do I exclude a cell from an average calculation when the cell.	Sam	Excel Discussion (Misc queries)	1	September 7th 05 05:16 PM
plotted Average	Micayla Bergen	Charts and Charting in Excel	4	July 15th 05 12:13 PM
What is this kind of average called?	havocdragon	Excel Worksheet Functions	3	June 24th 05 05:10 PM

All times are GMT +1. The time now is 05:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us