Forum Discussion

Iron Contributor

Aug 11, 2023

Formula required

Good day,

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

formula needed.xlsx9 KB

Riny_van_Eekelen
Aug 11, 2023
A_SIRAT That would be:
=SUMIFS($C2:$F2,$C$1:$F$1,J$1)

But why SUMIFS if you only have one criterion?

Riny_van_Eekelen
Platinum Contributor
Aug 11, 2023
A_SIRAT
- A_SIRAT
  Iron Contributor
  Aug 11, 2023
  Thank you.
  
  Could you do it with SUMIFS ?
  - Riny_van_Eekelen
    Platinum Contributor
    Aug 11, 2023
    A_SIRAT That would be:
    =SUMIFS($C2:$F2,$C$1:$F$1,J$1)
    
    But why SUMIFS if you only have one criterion?
OliverScheurich
Gold Contributor
Aug 11, 2023
A_SIRAT
=SUMPRODUCT(($C$1:$F$1=J$1)*($A$2:$A$7=$I2)*$C$2:$F$7)
You can try SUMPRODUCT.

formula needed.xlsx9 KB
- A_SIRAT
  Iron Contributor
  Aug 11, 2023
  Thank you for the SUMPRODUCT alternative.

Share

Resources