Posted to microsoft.public.excel.worksheet.functions

Tflight

external usenet poster

Posts: 8

sumproduct or...?

Hi,

I am trying to find the average of the total number for all the cells that
in their row have a number that is greater than 0 in one of the categories.

The formula I sort of have is:
IF(G6:G3270),AVERAGE(K6:K327)

I just learned about the function sumproduct, but I'm not sure if it would
work in this case. I don't really understand the function anyhow. Any help
would be appreciated.

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
Conditional SUMPRODUCT or SUMPRODUCT with Filters	Ted M H	Excel Worksheet Functions	4	August 14th 08 07:50 PM
Sumproduct	Coley	Excel Worksheet Functions	4	October 10th 07 12:09 AM
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM
sumproduct	Rob	Excel Worksheet Functions	2	February 5th 06 07:41 PM
=SUMPRODUCT	Jim	Excel Worksheet Functions	9	January 17th 06 04:52 PM

All times are GMT +1. The time now is 06:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us