Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Math Trigonometry Functions

 

=SUMIFS(B2

Input the formula: =SUMIFS(B2:E2,B5:E5,">=1%",B5:E5,"<=3%",B4:E4,">1%")