How to manipulate worksheets in Excel

How to manipulate worksheets in Excel? As mentioned from my other blogs – How to create a new excel file? – an Excel spreadsheet can have multiple sheets in one file. You can add, rename, move, delete, hide, unhide entire spreadsheet as long as to change colour of the spreadsheet. If you are using Excel … Read more

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