Excel 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 Create Multiple Choice Questions in an Excel Form

Excel can be very powerful if manipulating it intelligently. Not only can it be used to store and analyze data, but also Excel has many other usages. Therefore, today we launch the method of creating multiple choice questions in cells. You may possibly have received questionnaire in the form of Excel. And this is another application of Excel. The format of Excel allows the interface to be much clearer. What’s more, it is easy for people to collect the results. In some cells, there are some...

Read more »