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)