Thread
:
Multiple Sheets and Columns
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
Multiple Sheets and Columns
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)
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko