Use Excel's XLOOKUP to return a specific value or cumulative total from a grid with two criteria

Here's how to use the XLOOKUP function in MS365 to return a specific value, or cumulative total, using two criteria from a grid of data. You'll find a link in the comments to download the example file used in this video. The file also includes an 'old school' example, not covered in the video, for those using an older version of Excel without XLOOKUP and Dynamic Array functions. #microsoft #windows #office #ms365 #excel #xlookup #sumif #data #grid