excel

CloudOn – The Best Office Replacement For iPad

There are rumors out there that Microsoft is preparing to launch the much anticipated Office suite for iOS. Although the iPad is considered to be the best tablet on the market it still has some flaws, and one of the big ones is the fact that it does not have yet support for the best productivity program or a dedicated app (to talk in iOS terms).

Luckily for the iPad users, there is a multitude of applications on the App Store, and through them one can find some really good replacements for the Office suite. Though these apps cannot compete with… Continue to CloudOn - The Best Office Replacement For iPad

Display, Create & Edit Office Files (Word, Excel, PowerPoint) on iPad: CloudOn

As you all might know there are a lot of iPad users, as this gadget might be the most used tablet on the market. And there is no wonder regarding this fact: it offers a lot of useful features, it looks great, it works almost perfect and it provides its user with a lot of mobility. But there are certain limitations imposed by the fact that the operating system, iOS, allows only “in-house” software to be operated on this tablet. Don’t get me wrong, iOS is a great system, too, but its main drawback comes from the fact that I… Continue to Display, Create & Edit Office Files (Word, Excel, PowerPoint) on iPad: CloudOn

Excel Tutorials for Dummies – SUMIF Function

The purpose of the SUMIF function is to add the specified cells by a given criterion.

 

Using SUMIF, you combine 2 functions in one: SUM and IF, you don’t have to worry about 2 syntaxes and a nested formula is not needed.

 

 

 

The SUMIF syntax is basic: = SUMIF (range, criteria, sum_range)

Here is a short description of each argument:

Range: the array you want to evaluate and where you will apply the criterion.
Criteria: selecting a criterion you instruct Excel which cells to add and… Continue to Excel Tutorials for Dummies – SUMIF Function

Back to top