The Tamer
Well-known Member
- Joined
- Jun 10, 2004
- Messages
- 520
Hi
I've forgotten my Sumproduct syntax and would be appreciative of some advice.
I need to find sales for a given manager (list of names is D3:D60), but only for certain products (list of products is J3:J60 - and if the product isn't in J, then it may be in L3:L60)
Can I do this - if so, how?
Many thanks
Tamer
I've forgotten my Sumproduct syntax and would be appreciative of some advice.
I need to find sales for a given manager (list of names is D3:D60), but only for certain products (list of products is J3:J60 - and if the product isn't in J, then it may be in L3:L60)
Can I do this - if so, how?
Many thanks
Tamer