Posted to microsoft.public.excel.misc

karthik

external usenet poster

Posts: 48

Find Average using Sumproduct

Is there a way to find average based on multiple conditions.
I've been using Sumproduct formula to Sum all the cells but not sure how to
use it find average.

=SUMPRODUCT(--($B$4:$AT$4=$C$113),--($B$5:$AT$5=$C$115),$B7:$AT7)

Thanks for your help in advance...
--
Karthi

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
Find every 2 col's: SUMPRODUCT, AVERAGE..	nastech	Excel Discussion (Misc queries)	9	August 17th 07 05:32 AM
Find every 2 col's: SUMPRODUCT, AVERAGE..	nastech	Excel Discussion (Misc queries)	4	August 17th 07 05:22 AM
Find monthly average but have average automatically configured	kimbafred	Excel Discussion (Misc queries)	2	August 8th 07 12:28 AM
AVERAGE & SUMPRODUCT	Dave F[_2_]	Excel Discussion (Misc queries)	6	July 31st 07 11:53 PM
Using Sumproduct to Find Average	stevec	Excel Discussion (Misc queries)	2	August 3rd 06 10:06 PM

All times are GMT +1. The time now is 10:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us