Solvature - The daily tutorials and Interesting contents of Internet

New Abayas Design for Muslim women - 2014 ABAYAS LOOK

New Abayas Design for Muslim women - 2014 ABAYAS LOOK

…

22 Jun 2014

The Basic of Count and Sum of Ms Excel - Ms Excel Tutorials

<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO-TKAJubsZyufBQsASpR1BAU4DQiNeO3bP69tndI46PLkochheRChnA_qZ1idh6x7N53CDXtsa7Pqk6L1XZfD2G-_lJd1OUOqG1Gvs8XdCtw-1DquU2MVr9em5kumuwp2dDcIHJ2RXl0/s1600/8450446_f520.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO-TKAJubsZyufBQsASpR1BAU4DQiNeO3bP69tndI46PLkochheRChnA_qZ1idh6x7N53CDXtsa7Pqk6L1XZfD2G-_lJd1OUOqG1Gvs8XdCtw-1DquU2MVr9em5kumuwp2dDcIHJ2RXl0/s1600/8450446_f520.jpg" width="320" /></a></div>
<br />
The most used functions in Excel are the functions that count and sum. You can count and sum based on onecriteria or multiple criteria.</div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
<a href="https://www.blogger.com/null" id="count" name="count" style="color: #339ccb;"></a>Count</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To count the number of cells that contain numbers, use the COUNT function.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDGpRQ9ZM13f8Ek93B5LMPgrcl_vy7OB8dQg04izy3hWgL-HtpoyJXHVtHH8Io2SgUKDqysM84yEXYU4eZ9SetIYxBNOBahjWErIjiFSSiI1Wo_bUiZojWucYbz2yhhfIIki8g3ap45IY/s1600/count-function.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDGpRQ9ZM13f8Ek93B5LMPgrcl_vy7OB8dQg04izy3hWgL-HtpoyJXHVtHH8Io2SgUKDqysM84yEXYU4eZ9SetIYxBNOBahjWErIjiFSSiI1Wo_bUiZojWucYbz2yhhfIIki8g3ap45IY/s1600/count-function.png" /></a></div>
<br /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
</div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
<a href="https://www.blogger.com/null" id="countif" name="countif" style="color: #339ccb;"></a>Countif</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To count cells based on one criteria (for example, higher than 9), use the following COUNTIF function.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Countif Function" height="210" src="http://www.excel-easy.com/functions/images/count-sum-functions/countif-function.png" title="Countif Function" width="604" /></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
<a href="https://www.blogger.com/null" id="countifs" name="countifs" style="color: #339ccb;"></a>Countifs</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To count cells based on multiple criteria (for example, green and higher than 9), use the following COUNTIFS function.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Countifs Function" height="210" src="http://www.excel-easy.com/functions/images/count-sum-functions/countifs-function.png" title="Countifs Function" width="604" /></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
<a href="https://www.blogger.com/null" id="sum" name="sum" style="color: #339ccb;"></a>Sum</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To sum a range of cells, use the SUM function.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Sum Function" height="210" src="http://www.excel-easy.com/functions/images/count-sum-functions/sum-function.png" title="Sum Function" width="604" /></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
<a href="https://www.blogger.com/null" id="sumif" name="sumif" style="color: #339ccb;"></a>Sumif</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To sum cells based on one criteria (for example, higher than 9), use the following SUMIF function (two arguments).</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Sumif Function, Two Arguments" height="210" src="http://www.excel-easy.com/functions/images/count-sum-functions/sumif-function-two-arguments.png" title="Sumif Function, Two Arguments" width="604" /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To sum cells based on one criteria (for example, green), use the following SUMIF function (three arguments, last argument is the range to sum).</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Sumif Function, Three Arguments" height="210" src="http://www.excel-easy.com/functions/images/count-sum-functions/sumif-function-three-arguments.png" title="Sumif Function, Three Arguments" width="604" /></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
<a href="https://www.blogger.com/null" id="sumifs" name="sumifs" style="color: #339ccb;"></a>Sumifs</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To sum cells based on multiple criteria (for example, blue and green), use the following SUMIFS function (first argument is the range to sum).</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Sumifs Function" height="210" src="http://www.excel-easy.com/functions/images/count-sum-functions/sumifs-function.png" title="Sumifs Function" width="604" /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
General note: in a similar way, you can use the AVERAGEIF and AVERAGEIFS function to average cells based on one or multiple criteria.</div>

The Basic of Count and Sum of Ms Excel - Ms Excel Tutorials

The most used functions in Excel are the functions that count and sum. You can count and sum based on onecriteria or multiple criteria. Count To count the number of cells that contain numbers, use th…

22 Jun 2014

Data Validation In Excel - Ms Excel tutorials

<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS8lkePUdySLYtVIZxDCBOLJQbJiqf6_z3Qraun7WqcRFLvZgA7W3iT0HWJovvJJi09vz8OCKUlrqKavkaxwgpH6OCTFBurAbJThi6ayKsU1XVudU2ZcnsJ25_GO04sFbweAAkI_BS6sc/s1600/excel-data-validation-ribbon-686-183.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjS8lkePUdySLYtVIZxDCBOLJQbJiqf6_z3Qraun7WqcRFLvZgA7W3iT0HWJovvJJi09vz8OCKUlrqKavkaxwgpH6OCTFBurAbJThi6ayKsU1XVudU2ZcnsJ25_GO04sFbweAAkI_BS6sc/s1600/excel-data-validation-ribbon-686-183.png" /></a></div>
<br />
Use data validation in Excel to make sure that users enter certain values into a cell.</div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
Data Validation Example</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
In this example, we restrict users to enter a whole number between 0 and 10.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbFBAlEljJrTI1Gy2JzwXLFXjAd1RmOV8imtjfJ70Z4l9fgSgd0EAPjVavP1vSzTxVMAMeqstqP-AXzhoxrDYpQdzb1UmozcaoV6yMc8So3wH-AmA-rlH7lF71exyg3shJUR_7pHQyPUU/s1600/excel-data-validation-example.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbFBAlEljJrTI1Gy2JzwXLFXjAd1RmOV8imtjfJ70Z4l9fgSgd0EAPjVavP1vSzTxVMAMeqstqP-AXzhoxrDYpQdzb1UmozcaoV6yMc8So3wH-AmA-rlH7lF71exyg3shJUR_7pHQyPUU/s1600/excel-data-validation-example.png" /></a></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
</h3>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
Create Data Validation Rule</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
To create the data validation rule, execute the following steps.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
1. Select cell C2.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
2. On the Data tab, click Data Validation.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Click Data Validation" src="http://www.excel-easy.com/basics/images/data-validation/click-data-validation.png" title="Click Data Validation" /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
On the Settings tab:</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
3. In the Allow list, click Whole number.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
4. In the Data list, click between.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
5. Enter the Minimum and Maximum values.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Validation Criteria" src="http://www.excel-easy.com/basics/images/data-validation/validation-criteria.png" title="Validation Criteria" /></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
Input Message</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
Input messages appear when the user selects the cell and tell the user what to enter.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
On the Input Message tab:</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
1. Check 'Show input message when cell is selected'.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
2. Enter a title.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
3. Enter an input message.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Enter Input Message" src="http://www.excel-easy.com/basics/images/data-validation/enter-input-message.png" title="Enter Input Message" /></div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
Error Alert</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
If users ignore the input message and enter a number that is not valid, you can show them an error alert.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
On the Error Alert tab:</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
1. Check 'Show error alert after invalid data is entered'.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
2. Enter a title.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
3. Enter an error message.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Enter Error Message" src="http://www.excel-easy.com/basics/images/data-validation/enter-error-message.png" title="Enter Error Message" /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
4. Click OK.</div>
<h3 style="background-color: white; color: #3e3530; font-family: Arial, Helvetica, sans-serif; font-size: 1.6em; font-weight: normal; margin: 0px; padding: 0px; text-align: justify;">
Data Validation Result</h3>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
1. Select cell C2.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Input Message" src="http://www.excel-easy.com/basics/images/data-validation/input-message.png" title="Input Message" /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
2. Try to enter a number higher than 10.</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
Result:</div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
<img alt="Error Alert" src="http://www.excel-easy.com/basics/images/data-validation/error-alert.png" title="Error Alert" /></div>
<div style="background-color: white; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 21.600000381469727px; text-align: justify;">
Note: to remove data validation from a cell, select the cell, on the Data tab, click Data Validation, and then click Clear All. You can use Excel's <span style="color: #339ccb;">Go To Special</span> feature to quickly select all cells with data validation.</div>

Data Validation In Excel - Ms Excel tutorials

Use data validation in Excel to make sure that users enter certain values into a cell. Data Validation Example In this example, we restrict users to enter a whole number between 0 and 10. Create Data…

22 Jun 2014

Load more posts

New Abayas Design for Muslim women - 2014 ABAYAS LOOK

The Basic of Count and Sum of Ms Excel - Ms Excel Tutorials

Data Validation In Excel - Ms Excel tutorials

Fashion

Ms Excel