Try this...

D1:
=(SUMIF($A$2:$A$20,C1,$B$2:$B$20)+SUMIF($A$2:$A$20 ,C1,$E$2:$E$20)+
SUMIF($A$2:$A$20,C1,$f$2:$f$20))/COUNTIF($A$2:$A$20,C1)

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"pjr" wrote in message
...
This is just about right... but to get the information from four different
columns, I've done something that looks more like this:

D1:
=SUMIF($A$2:$A$20,C1,$B$2:$B$20)+SUMIF($A$2:$A$20, C1,$E$2:$E$20)+SUMIF($A$2:$A$20,C1,$f$2:$f$20)/COUNTIF($A$2:$A$20,C1)

The trouble now is that the last +SUMIF part is being divided by the
COUNTIF
part before it gets added to the other SUMIF's.

it wont let me bracket or put a parenthesis around all the SUMIF's.

is there another way to change the order of operations?

"Ron Coderre" wrote:

I think I may have something you can use....

With
A2:A20 contains either "FP" or "NP"
B2:B20 contains amounts

C1: FP
C2: NP

This formula returns the average of the FP values:
D1: =SUMIF($A$2:$A$20,C1,$B$2:$B$20)/COUNTIF($A$2:$A$20,C1)

Copy that formula to D2 to see the average of NP values.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"pjr" wrote in message
...
the two main categories are "FP"(for profit) and "NP"(non profit). One
column
is devoted to distinguishing between the two for each application. Is
there a
way to pull data from cells that only sit in the same row as an "FP" or
"NP" ?


"Ron Coderre" wrote:

Perhaps there's a particular pattern associated with the cells you
want
to
average.
Example:
.. A word (eg "Total") in a cell to the side of it? or one cell up and
to
the
left?

Have anything like that?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"pjr" wrote in message
...
Sorry for not being more specific. The arguments are not evenly
spaced.
I'm
making a spreadsheet for the results of an application process. the
applications are listed in order, 1 thru 126, but the formula that I
am
making is based on information that shows up throughout the list,
independant
of their application number.

"Ron Coderre" wrote:

If the arguments are evenly spaced (eg every 3rd cell...A1, A4, A7,
etc),
let us know.
There may be options that will increment the cell references
automatically.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"pjr" wrote in message
...
Is it possible to have more than thirty arguments in a single
average
function? The arguments are not contiguous, so i can't just make
them
into
data points...

What should I do?