Need Help with this

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top