office-winner

What is the use of Sumif formula?  Sums items in a list matching a condition Syntax of Sumif formula: sumif(in this range, values meeting this criteria, [sum-this-range]) Examples of Excel Sumif formula:   sumif(A1:A20, 3) = sums the cells with a value of "3" sumif(A1:A20, 3, b1:b20) = same as above but adds values in B1:B20 SUMIF function syntax The SUMIF function has the following syntax:          =SUMIF( range , criteria ,sum_range) range is the range of cells you want to add up. It is required for the function to work. criteria is the criteria which must be met for a cell to be included in the total. It is also required. sum_range is the range of cells that will be added up. It is optional; if you leave it out, Excel will check the criteria against the sum_range. In the two examples above, the first example doesn't need you to provide a sum_range, while the second example does. One of t...

Array Formulas Many of the formulas described here are Array Formulas, which are a special type of formula in Excel.  If you are not familiar with Array Formulas, click here. Array To Column Sometimes it is useful to convert an MxN array into a single column of data, for example for charting (a data series must be a single row or column).  Click here for more details. Averaging Values In A Range You can use Excel's built in =AVERAGE function to average a range of values.  By using it with other functions, you can extend its functionality. For the formulas given below, assume that our data is in the range A1:A60. Averaging Values Between Two Numbers Use the  array formula =AVERAGE(IF((A1:A60>=Low)*(A1:A60<=High),A1:A60)) Where Low and High are the values between which you want to average. Averaging The Highest N Numbers In A Range To average the N largest numbers in a range, use the  array form...

Windows - On either side of the spacebar, outside the Alt key, is a key with the Windows logo. Holding the Windows key down and pressing another key will initiate quite a few actions. Some of the more common are listed in the table below: + F to display Find: All Files + F1 to display Help + R to display the Run command + M to minimize or restore all windows + E to display Windows Explorer + Break to display System Properties + Tab to cycle through buttons on the task bar Shift + + M to undo minimize all windows to display the Start menu and then press U to display the Turn Off Computer menu, press U again (on laptops) or press S (on desktops) to Turn Off the computer. + D to quickly get to your Desktop [Thanks Charlotte!] If your computer has XP installed and you want to lock your computer when you walk away from it use + L . OK, I won't leave you hanging. Your...

Mathematical Functions Text Functions Logical & Reference Functions Date & Time Functions Financial Functions Information Functions Average Formula Int Formula Mod Formula Rand Formula Round Formula Sum Formula Concatenate Formula Find Formula Left Formula Len Formula Lower Formula Mid Formula Proper Formula Rept Formula Substitute Formula Trim Formula Upper Formula Value Formula And Formula Countblank Formula Countif Formula If Formula Large Formula Max Formula Min Formula Not Formula Or Formula Small Formula Sumif Formula Vlookup Formula Day Formula Hour Formula Minute Formula Month Formula Networkdays Formula Now Formula Second Formula Today Formula Weekday Formula Year Formula Fv Formula Ipmt Formula Npv Formula Pmt Formula Ppmt Formula Column Formula Isblank Formula Iserror Formula Isnumber Formula Istext Formula Row Formula