How to do summation or counting in Excel with multiple wildcard criteria? – new excel functions

Example of sumifs function

We can use the following functions to do summation or counting in Excel with multiple wildcard criteria Summation or counting in Excel with multiple wildcard criteria However, both Sumif and Countif only allows single criteria. SUMIFS & COUNTIFS Since Excel 2007, Microsoft have introduced two new functions called SUMIFS & COUNTIFS They are close to sumif and … Read more

What is a Ribbon in Excel – Excel Interview Questions

This blog is going to answer following questions regarding to Ribbon in Excel.   What is a Ribbon in Excel? is available since MS-Office 2007. Replaced menus and toolbars in previous Office version. Ribbon have the same functionality as as menus or toolbar. Ribbon reorganised those buttons in a more user friendly way. Ribbons have … Read more