Office Solutions

How to Merge Multiple Worksheets through Excel VBA

Excel is so popular among people mainly because it combines the function of VBA. Sometimes, a few lines of VBA can achieve a lot of functions. Thus, now we will introduce the VBA to merge multiple worksheets with the same format. In your work, sometimes you need to ask many people some questions through the form of Excel. For example, suppose you are a teacher, and you have sent your students the Excel files. And in this file, students need to make choices on different tasks. And now you...

Read more »

How to Average Values Satisfying Specified Conditions with AVERAGEIF and AVERAGEIFS Functions

Excel possesses many different functions that can help you achieve varies purposes. What’s more, different functions have different criteria settings. Therefore, now we will use the AVERAGEIF and AVERAGEIFS functions to average values satisfying specified conditions. In your daily work, the average value is one of the performance measures. Besides, according to the average value, you can also analyze the tendency of your products or services in the market. And in the image below, this is...

Read more »

How to Sum Up Values Based on Some Conditions via SUMPRODUCT Function

Excel has many functions that can help with your work. And there will be different functions to achieve different purpose. Therefore, today we will launch the usage of SUMPRODUCT function to sum up values based on certain conditions. Sometimes you may get a mess table. But you have to calculate certain numbers. For example, in the image below, there are sales volumes of different people. And it includes many products and different months. If you want to calculate the volume of apple that...

Read more »