=SUMIFS(B2:E2,B5:E5,">=1%",B5:E5,"<=3%",B4:E4,">1%") : SUMIFS « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Math Trigonometry functions
  3. SUMIFS
Input the formula: =SUMIFS(B2:E2,B5:E5,">=1%",B5:E5,"<=3%",B4:E4,">1%")
Input the formula: =SUMIFS
20.52.SUMIFS
20.52.1.SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2…) adds the cells in a range that meet multiple criteriaSUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2…) adds the cells in a range that meet multiple criteria
20.52.2.=SUMIFS(B2:E2,B5:E5,">=1%",B5:E5,"<=3%",B4:E4,">1%")=SUMIFS(B2:E2,B5:E5,=1%",B5:E5,"<=3%",B4:E4,">1%")" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/sumifsb2e2b5e5gt1b5e5lt3b4e4gt1___Input_Formula_sumifsb2e2b5e51b5e53b.PNG" width=200 height=40>