N
Need_Help
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
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