One of the first questions in my interviews for the internships was “Are you proficient in Excel?” Yes I am.
I was familiar with the graphing functions of Excel 2007 rather than the counting and sum functions initially. This is because most of the lab reports I have written are focused on statistics, i.e. the standard deviation of the experimental values.
Before I outline the formulas, here are the input definitions.
The criterion (criteria is the plural form) that you define may be a word, number, or a date. The range is the cells from which you will be pulling data from.
These are the three formulas during my internships that I used frequently to save time which could be spent doing another task.
- Counts the number of cells in a range that are not empty
- Enter as: =COUNTA(value1,value2,…)
- Counts the number of cells in a range that meets a certain condition
- Adds the cells specified by a given condition or criteria
When to use a counting function:
- Is the criterion text or a number? Yes.
- Do you want to know how many? Yes.
When to use a sum function:
- Is the criterion text? No.
- Is the criterion numerical? Yes.
- Do you want to know the sum? Yes.
- The formula will ignore text data when adding up the figures.
I’ve found these to be helpful outside of the workplace. Because I plan on being on EdenFantasys long-term, I created a spreadsheet. Using these formulas I know how many products I have wish listed and what my budget is for each order I make. All I have to do is update the cells and voilá, the calculations are done.