Functions can be used to do many things and one thing I am going to use them for is to pull in today’s and yesterdays sales from a table of sales of products.
For this example, we have a table of sales of products. It gets updated throughout the day as sales come in. We want to pull in today’s sales and yesterday’s sales for a quick look at how they are doing currently.
So say today is March 14, 2015. We want to pull in all of today’s sales and sum them up. To do this we will use TODAY and SUMIF Functions.
We will use this formula in cell F2:
What this does is look in the range of A2 to A11. That is the list of dates.
The criteria is today’s date. We get that by using the function TODAY. If you actually put March 14, 2015 in there, you would have to update it tomorrow and everyday. By using TODAY, it constantly will look for today’s date.
Then it will SUM up the range of B2 to B11 only when it finds a match in A2 to A11. Those row numbers should match or you could get an error.
You can also get yesterday’s sales by just putting a -1 after TODAY. So the formula just looks like TODAY()-1 to make it yesterday.
To see more of what Excel Functions can do, go to bit.ly/ExcelFormulaCrashCourse