Hi,
I am using sumproduct to get sales by product by manager by month like this:
Manager, Product, Jan05, Feb05...Dec05
A A 30 40 50
D Z 0 15 40
and I am doing this sumproduct((A10:A100=Manager)*(B10:B100=Product)*(C10:C100), and this works for january, but what if I want to do it for Feb05, or other month automaticly? Should I use sumproduct?
Thanks.
Antonio
I am using sumproduct to get sales by product by manager by month like this:
Manager, Product, Jan05, Feb05...Dec05
A A 30 40 50
D Z 0 15 40
and I am doing this sumproduct((A10:A100=Manager)*(B10:B100=Product)*(C10:C100), and this works for january, but what if I want to do it for Feb05, or other month automaticly? Should I use sumproduct?
Thanks.
Antonio