SOLVED

# Sumproduct or sumifs ?

Copper Contributor

# Sumproduct or sumifs ?

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

# Re: Sumproduct or sumifs ?

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.

# Re: Sumproduct or sumifs ?

@HansVogelaarthank you it worked with formula

1 best response

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

# Re: Sumproduct or sumifs ?

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.