Excel's Sumif and Sumifs allows you to query your tabular data for numerical answers to your questions like what was our sales or costs for January last year?Or in the case of this example here what was the total volume traded on the NYSE for ticker "abev"? The YouTube video above takes you through a practical example of sumif and sumifs using the tabular … [Read more...] about What Does Excel Sumif and Sumifs Do?
All Articles
How To Find The Last Row In an Excel VBA Range
You are adding data on a consistent basis to your spreadsheet, and you need to have a macro that references the last row that was just added to your Excel spreadsheet data range or table. This article and associated video will show you how to do just that. Fig 1 So similar to "Fig 1" above you would like to reference row 14 of the table and possibly iterate over each … [Read more...] about How To Find The Last Row In an Excel VBA Range
what does excel dsum do
Dsum queries your Excel data and provides answers based on the criteria that you provide to the dsum function. More to the point in order to use dsum you have to decide to layout your spreadsheet using best practice spreadsheet design principles. Get the spreadsheet used in the tutorial above. Also get updates when new blog or video tutorials are … [Read more...] about what does excel dsum do
what does vlookup do
This article and associated youtube video will explain what vlookup does and the best way to organise your spreadsheet data to the get most out of vlookup and how to use it to join two datasets together. Vlookup allows you to get extra information from another data range by using a unique identifer that populates the first column of the data range that your are looking … [Read more...] about what does vlookup do
How To Resize A Named Range In Excel VBA
To resize a named range in Excel VBA it's best to get an object reference to the range and then use the Excel VBA resize method to resize the range. With the resized range object you then set it's name property to the range name that you want resized. Excel will behind the scenes delete the old range name and replace it with the one you have just created. The spreadsheet … [Read more...] about How To Resize A Named Range In Excel VBA