This video demonstrates how to sum between two dates in Excel. In our scenario we want to calculate total revenue. The functions used in this video are SUMIFS, EOMONTH and EDATE. Download the featured file here.
This video will show how to achieve two things in the context of using Lookup functions such as VLOOKUP, LOOKUP, XLOOKUP, INDEX & MATCH. You can download the featured files here. XLOOKUP Version - requires Office 365 or Excel Online. Non XLOOKUP Version - works in any version of Excel. Sum all matching values Here we…Read More
To perform a lookup on multiple criteria you will need to concatenate (join up) your lookup values and concatenate the corresponding columns in your lookup table. This video tutorial looks at three ways you can achieve this. There are some notes below the the video to help you understand, but really you need to watch…Read More