Conditional summing - formula help

C

Christine Dohm

I have a spreadsheet that is used to key daily time totals
for our department. The times are keyed by category, and
by employee.

I can easily create a summary by employee using:
=SUMIF(Analyst,TeamInit,INDIRECT(Header))

Name Init Cat01 Cat02
My Name MN 80:00 90:00

"Analyst" is the cell on the entry page with employee name
"TeamInit" is the cell on the summary w/employee's initials
"Header" is a cell pointing to the cell range I want to sum

Now, I need to sum by employee AND by month.

I have a cell on the entry page that contains the month
number, and a cell on the summary page containing the
month number that I want to sum.

I tried SUMPRODUCT, but I get a #NUM error:

=SUMPRODUCT((Month=ChosenMonth)*(Analyst=TeamInit)*
(INDIRECT(Header)))

Where "Month" is the month on the entry page
and "ChosenMonth" is the month on the summary page.

Is there a better way to do this? Or, could someone
correct my formula?

Thanks!!
 
F

Frank Kabel

Hi
Ho are your names defined. Ranges like A:A

If yes this won't work. SUMPRODUCT only accepts ranges like
A1:A1000

so try chaing your name definition
 
Top