Use absolute references:

=SUMPRODUCT(--(Details!$F$2:$F$105=A$10),--(Details!$G$2:$G$105=some_module),Details!$E$2:$E$ 105)

Biff

"Tom D" wrote in message
...
Okay, this works for what I need! Is there anyway to 'lock' the formula
against that creep when I cut and paste? I have to edit each one bck to
F2,
E2, etc.

TD

"T. Valko" wrote:

Ooops!

=SUMPRODUCT(--(Details!$F2:$F105=A$10),--(Details!$G2:$G105=some_module),Details!$E2:$E107)

I just noticed that Details!$E2:$E107 is not the same size as the other
references. *ALL* ranges must be the same size:

=SUMPRODUCT(--(Details!$F2:$F105=A$10),--(Details!$G2:$G105=some_module),Details!$E2:$E105)

Biff

"T. Valko" wrote in message
...
Try something like this:

=SUMPRODUCT(--(Details!$F2:$F105=A$10),--(Details!$G2:$G105=some_module),Details!$E2:$E107)

Biff

"Tom D" <Tom wrote in message
...
I have a sheet called Details that has 3 columns that I want to create
a
summary for on another sheet (called summary). One column has
different
peoples names (F). Another column has different module names(G). The
addtion column has a number in it (E). What I am trying to get is a
summary of how many (E) each person (F) has per module (G).

I have a formula that gets all the totals in one bucket, but whem I
try
to
add the 'G' range, it tells me its too complex. I am pretty new to
this...

SUMIF(Details!$F2:$F105,A$10,Details!$E2:$E107)