SumIFs Multiple Criterias on Same Column

     

  • Apply multiple criteria on single column using SUMIFS function
  • =SUMIFS(B2:B8,A2:A8,{"Apple","Grapes"})+SUMIFS(B2:B8,A2:A8,"Banana")

    • Download The Workbook

     

Hi Everyone,
Welcome to Excel Functions Tutorial. This Tutorial provides comprehensive knowledge on Excel formulas to the user. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli