SOLVED

Sumproduct or sumifs ?

Copper Contributor

1) I need to calculate the total incentives employe made in a particular month. Data should be month wise
2) another formula to show the total incentives made by each employe (without using sum formula)

2 Replies
best response confirmed by BerlyLinkin (Copper Contributor)
Solution

@BerlyLinkin 

One option would be a pivot table: add Emp ID to the Rows area, Month to the Columns area and Incentives to the Values area.

 

If you prefer formulas:

In G3:

=SUMIFS($C$3:$C$10000, $B$3:$B$10000, $F3, $D$3:$D$10000, G$2)

Fill to the right to J3, then down to row 11.

 

In L3:

=SUMIFS($C$3:$C$10000, $B$3:$B$10000, $F3)

Fill down to L11.

@HansVogelaarthank you it worked with formula

1 best response

Accepted Solutions
best response confirmed by BerlyLinkin (Copper Contributor)
Solution

@BerlyLinkin 

One option would be a pivot table: add Emp ID to the Rows area, Month to the Columns area and Incentives to the Values area.

 

If you prefer formulas:

In G3:

=SUMIFS($C$3:$C$10000, $B$3:$B$10000, $F3, $D$3:$D$10000, G$2)

Fill to the right to J3, then down to row 11.

 

In L3:

=SUMIFS($C$3:$C$10000, $B$3:$B$10000, $F3)

Fill down to L11.

View solution in original post