charlesloves2read
Board Regular
- Joined
- Aug 11, 2010
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
Hi,
In Column A, I have two customers, A and B.
In Column B, I have 4 factory locations, North, South, East, West.
In Column C, I have Revenue.
How do i use Sumproduct to obtain the Total Revenue for Customer A in Factory Location North AND South.
I only know how to obtain Total Revenue for Customer A in ONE Factory Location.
Thanks!
This is a simplified example of an exercise i am supposed to do at work.
In Column A, I have two customers, A and B.
In Column B, I have 4 factory locations, North, South, East, West.
In Column C, I have Revenue.
How do i use Sumproduct to obtain the Total Revenue for Customer A in Factory Location North AND South.
I only know how to obtain Total Revenue for Customer A in ONE Factory Location.
Thanks!
This is a simplified example of an exercise i am supposed to do at work.