SOLVED

Iron Contributor

# Formula required

Good day,

Please assist with a formula. I have explained in the attached file.

7 Replies

# Re: Formula required

``=SUMPRODUCT((\$C\$1:\$F\$1=J\$1)*(\$A\$2:\$A\$7=\$I2)*\$C\$2:\$F\$7)``

You can try SUMPRODUCT.

# Re: Formula required

Thank you.

Could you do it with SUMIFS ?
best response confirmed by A_SIRAT (Iron Contributor)
Solution

# Re: Formula required

@A_SIRAT That would be:

``=SUMIFS(\$C2:\$F2,\$C\$1:\$F\$1,J\$1)``

But why SUMIFS if you only have one criterion?

# Re: Formula required

Thank you.

Because I wanted to know where I got it wrong. It can also help in future when I have more than one criterion.
Sorry I learnt SUMIFS first and prefers it

# Re: Formula required

Thank you for the SUMPRODUCT alternative.

# Re: Formula required

I learnt SUMIF() first, but prefer always to use SUMIFS() since it has more logical sequence of parameters.

1 best response

Accepted Solutions
best response confirmed by A_SIRAT (Iron Contributor)
Solution

# Re: Formula required

@A_SIRAT That would be:

``=SUMIFS(\$C2:\$F2,\$C\$1:\$F\$1,J\$1)``

But why SUMIFS if you only have one criterion?