Office Solutions

How to Use the SUMIF Function to Perform a Conditional Sum

The function in Excel enables it to handle complex data. Thus many people choose to apply Excel as their office software. And of course there are many different functions for different purpose. Thus, today we choose to analyze the feature of SUMIF function. SUMIF function can calculate the sum of certain numbers in your specified criteria. In the image below, you need to calculate the total sales volume. And at the same time, you want to add the numbers that are higher than 500. But...

Read more »

How to Find Out All Cells with Same Values in a Row

With the amazing attributes in Excel, many people and companies select it as their first choice. Some of the Excel tips are still unknown to many users. Therefore, we will introduce the function to find cells cells with same values in a row in today’s article. Excel has a function of filter. What’s more, it can select certain rows in one column with certain condition. However, sometimes you will need to select certain elements in a row. But the filter in Excel cannot achieve this...

Read more »

How to Recover Outlook Data from Temporary Outlook Files

When your Outlook is subject to a crash but you cannot recover Outlook data from the original Outlook file, you can still utilize its temporary file to restore corrupted data. If we meet an Outlook crash during accessing an Outlook file, Outlook may create a temporary file automatically, which locates at the same folder as the original Outlook file. Besides, this file is usually hidden, thus as a rule we cannot see it. Therefore, so as to find out the temporary file, we should make it...

Read more »