hakim_tanzil
Board Regular
- Joined
- May 10, 2012
- Messages
- 51
Hi all,
Assuming my input sheet is:
Name A1 A2 A3 A4 A5
Arron 1 5 3 2 2
Bravo 6 3 2 1 3
Aaron 3 5 6 7 3
Charlie 2 2 3 4 3
Bravo 5 3 4 3 2
In my calculation sheet:
A1 A2 A3 A4 A5
Aaron
Bravo
Charlie
So, I want to use the SUMIF formula in my calculation sheet (cell B2:F3) to sum up everything from input sheet, based on names and the product name (A1,A2,A3, etc). Thanks and look forward to your inputs on this.
Assuming my input sheet is:
Name A1 A2 A3 A4 A5
Arron 1 5 3 2 2
Bravo 6 3 2 1 3
Aaron 3 5 6 7 3
Charlie 2 2 3 4 3
Bravo 5 3 4 3 2
In my calculation sheet:
A1 A2 A3 A4 A5
Aaron
Bravo
Charlie
So, I want to use the SUMIF formula in my calculation sheet (cell B2:F3) to sum up everything from input sheet, based on names and the product name (A1,A2,A3, etc). Thanks and look forward to your inputs on this.