Sumproduct or not?

[anogueira]

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

 

[Aladin Akyurek]

Aladin, Jan05 are true dates.
...

Book7
	A	B	C	D	E
1	Manager	Product	Jan05	Feb05	Mar05
2	A	A	30	40	50
3	D	Z	0	15	40
4	A	A	45	55	50
5
6	Month/Year	Manager	Product	Total
7	Jan05	A	A	75
8
Sheet1

D7:

=SUMPRODUCT(--($A$2:$A$4=B7),--($B$2:$B$4=C7),INDEX($C$2:$E$4,0,MATCH(A7,$C$1:$E$1,0)))

If so desired, A7 to C7 can be choices from dropdown lists.