Excel 2007 COUNTA Function
Saturday November 21, 2009
There are a number of functions in Excel that will count cells for you rather than add or multiply the data in those cells. One of these COUNT functions that I use regularly is the COUNTA function. I use it to keep track of the number of students I have in each of my classes.
COUNTA tells you the number of non-blank cells that are present in a specified range. The cells can contain numbers, dates, or just plain text labels.
To find out the specifics of about this function read the article on Excel 2007 COUNTA Function.
Related Articles
COUNTA tells you the number of non-blank cells that are present in a specified range. The cells can contain numbers, dates, or just plain text labels.
To find out the specifics of about this function read the article on Excel 2007 COUNTA Function.
Related Articles
Excel 2007 SUMIFS Function
Wednesday November 18, 2009
A recent post in this site's forum ask a question about combining the AND function with the SUMIF function in order to add up data that met specific criteria in two other data ranges .
Rather than do this, a simpler way would be to use the SUMIFS function which is similar to SUMIF except that SUMIFS allows you to specify from 2 to 127 criteria ranges rather than just one.
For example, the function can be used to pick out data from specific years. This would allow you to add up only the profits for say 2006 and 2007 from a worksheet containing data from 2004 to 2009.
To find out the details, read the article on using the Excel 2007 SUMIFS Function.
Related Articles
Rather than do this, a simpler way would be to use the SUMIFS function which is similar to SUMIF except that SUMIFS allows you to specify from 2 to 127 criteria ranges rather than just one.
For example, the function can be used to pick out data from specific years. This would allow you to add up only the profits for say 2006 and 2007 from a worksheet containing data from 2004 to 2009.
To find out the details, read the article on using the Excel 2007 SUMIFS Function.
Related Articles
Excel 2007 SUMIF
Monday November 16, 2009
Two of the most useful functions available in Excel are the IF function and the SUM function:
SUMIF makes it easier to add up values if a certain criterion is met. The criterion can test the data to be summed or an entirely different range of data.
To find out more, read the short article on the Excel 2007 SUMIF function.
Related Articles
- The IF function introduces decision making which adds flexibility to your to spreadsheets.
- The SUM function makes it easy to add up data located in rows or columns.
SUMIF makes it easier to add up values if a certain criterion is met. The criterion can test the data to be summed or an entirely different range of data.
To find out more, read the short article on the Excel 2007 SUMIF function.
Related Articles
Excel 2007 AVERAGEIF
Friday November 13, 2009
One of Excel's Something - If functions is the AVERAGE IF function.
AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.
The AVERAGE function is used to find the average value in a range of data while the IF function allows you to have different result occur depending on whether a specific condition is met or not.
AVERAGE IF makes it easier to find the average value if specific criteria are met. This makes it possible to set up trigger cells in a spreadsheet so that the data is averaged only when a certain level is reached.
To find out more, read the short article on the Excel 2007 AVERAGEIF function.
Related Articles
AVERAGE IF combines two very useful and well used functions - the IF function and the AVERAGE function.
The AVERAGE function is used to find the average value in a range of data while the IF function allows you to have different result occur depending on whether a specific condition is met or not.
AVERAGE IF makes it easier to find the average value if specific criteria are met. This makes it possible to set up trigger cells in a spreadsheet so that the data is averaged only when a certain level is reached.
To find out more, read the short article on the Excel 2007 AVERAGEIF function.
Related Articles
Excel 2007 EOMONTH Function
Wednesday November 11, 2009
One Excel function that can be used to calculate the number of days between two dates is the EOMONTH function.
Short for End of Month Function, EOMONTH is mainly used to calculate the maturity date for investments that fall due on the last day of the month.
The function can also be used to find the start or end date for projects.
To find out the details of using this function, read the article on Excel 2007 EOMONTH Function.
Related Articles
Short for End of Month Function, EOMONTH is mainly used to calculate the maturity date for investments that fall due on the last day of the month.
The function can also be used to find the start or end date for projects.
To find out the details of using this function, read the article on Excel 2007 EOMONTH Function.
Related Articles
Excel 2007 TRANSPOSE Function
Monday November 9, 2009
On occasion there is a need to transfer a row of data into a column. This might be done when re-vamping a spreadsheet or when creating a summary table of information.
Whatever the reason, Excel has a function, the TRANSPOSE function, that simplifies the task. This function will copy a row of data and place it in a column or copy data from a column into a row.
To find out the details of using this function read the article on the Excel 2007 TRANSPOSE Function.
Related Articles
Whatever the reason, Excel has a function, the TRANSPOSE function, that simplifies the task. This function will copy a row of data and place it in a column or copy data from a column into a row.
To find out the details of using this function read the article on the Excel 2007 TRANSPOSE Function.
Related Articles
Excel 2007 HLOOKUP Function
Friday November 6, 2009
After discussing Excel's VLOOKUP function, I thought I should follow that up with the HLOOKUP function.
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized in your spreadsheets.
If the data is organized in columns, you would use VLOOKUP, if the data is kept in rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the Excel 2007 HLOOKUP Function.
Related Articles
Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized in your spreadsheets.
If the data is organized in columns, you would use VLOOKUP, if the data is kept in rows, you would use HLOOKUP.
For details on how to use the HLOOKUP function in your spreadsheets, including an example, read the article on the Excel 2007 HLOOKUP Function.
Related Articles
Excel 2007 VLOOKUP Step by Step Tutorial
Wednesday November 4, 2009
If you store large amount in spreadsheets, Excel's VLOOKUP is a handy function to know. It allows you to easily locate specific data in a database or list.
For example, VLOOKUP can be used to find the price of an item located in a large inventory list. VLOOKUP will not only lookup the price but you can also get it to insert that price into an order form, so filling out online order forms becomes quite straightforward.
For details on how to setup and use the VLOOKUP function in your spreadsheets, read the article Excel 2007 VLOOKUP Step by Step Tutorial.
Related Articles
For example, VLOOKUP can be used to find the price of an item located in a large inventory list. VLOOKUP will not only lookup the price but you can also get it to insert that price into an order form, so filling out online order forms becomes quite straightforward.
For details on how to setup and use the VLOOKUP function in your spreadsheets, read the article Excel 2007 VLOOKUP Step by Step Tutorial.
Related Articles
Excel 2007 EDATE Function
Monday November 2, 2009
One Excel function that can be used to calculate the number of days between two dates is the EDATE function.
It is mainly used to calculate the maturity date for an investment that falls on the same day of the month as the issue date or due date for a project.
The function can also be used to find the start date rather than the due date by using negative numbers when writing the function.
To find out the details of using this function, read the article on Excel 2007 EDATE Function.
Related Articles
It is mainly used to calculate the maturity date for an investment that falls on the same day of the month as the issue date or due date for a project.
The function can also be used to find the start date rather than the due date by using negative numbers when writing the function.
To find out the details of using this function, read the article on Excel 2007 EDATE Function.
Related Articles
Excel TODAY Function
Saturday October 31, 2009
Excel 2007 TODAY Function
© Ted French
You could just type the date into a cell, or, if you desire more flexibility, you can use the TODAY function, which is one of Excel's date functions.
To find out how to use the function, read the article on using the Excel 2007 TODAY Function.
Related Articles