Need Help with this
 

I'm using a SUMPRODUCT that works but I want it to sum the hours when I use a
filter.
This is my SUMPRODUCT:
=SUMPRODUCT(--(sheet1!$a$1:$a$14=B3),--(sheet1!$b$1:$b$14=A3),--(sheet1!$c$1:$c$14))

I want to be able to filter on the year column and only get the sub-totals
for that year when my criteria matches.

YEAR Group Hours
2007 1 25
2007 2 20
2007 3 15
2008 1 35
2008 1 65
2008 2 21
2008 3 8
2008 3 5
2008 3 9
2009 1 45
2009 1 65
2009 2 25
2009 2 100
2009 2 10

Need Help with this
 

See your other post

--
Biff
Microsoft Excel MVP


"Need_Help" wrote in message
...
I'm using a SUMPRODUCT that works but I want it to sum the hours when I
use a
filter.
This is my SUMPRODUCT:
=SUMPRODUCT(--(sheet1!$a$1:$a$14=B3),--(sheet1!$b$1:$b$14=A3),--(sheet1!$c$1:$c$14))

I want to be able to filter on the year column and only get the sub-totals
for that year when my criteria matches.

YEAR Group Hours
2007 1 25
2007 2 20
2007 3 15
2008 1 35
2008 1 65
2008 2 21
2008 3 8
2008 3 5
2008 3 9
2009 1 45
2009 1 65
2009 2 25
2009 2 100
2009 2 10

Need Help with this
 

Got it. That worked.
Thank you very much.

"T. Valko" wrote:

See your other post

--
Biff
Microsoft Excel MVP


"Need_Help" wrote in message
...
I'm using a SUMPRODUCT that works but I want it to sum the hours when I
use a
filter.
This is my SUMPRODUCT:
=SUMPRODUCT(--(sheet1!$a$1:$a$14=B3),--(sheet1!$b$1:$b$14=A3),--(sheet1!$c$1:$c$14))

I want to be able to filter on the year column and only get the sub-totals
for that year when my criteria matches.

YEAR Group Hours
2007 1 25
2007 2 20
2007 3 15
2008 1 35
2008 1 65
2008 2 21
2008 3 8
2008 3 5
2008 3 9
2009 1 45
2009 1 65
2009 2 25
2009 2 100
2009 2 10