A_SIRATIron ContributorAug 11, 2023SolvedFormula required Good day, Please assist with a formula. I have explained in the attached file. formula needed.xlsx9 KBRiny_van_Eekelen to A_SIRATAug 11, 2023A_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 to A_SIRATAug 11, 2023A_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 to A_SIRATAug 11, 2023A_SIRAT That would be:=SUMIFS($C2:$F2,$C$1:$F$1,J$1) But why SUMIFS if you only have one criterion?
OliverScheurichGold ContributorAug 11, 2023A_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
