Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
How to correct a #VALUE! error - Microsoft Support
#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be hard to find the exact cause of it. The information on this page shows common problems and solutions for the error.
How to correct a #VALUE! error in the COUNTIF/COUNTIFS function
Solution: Open the linked workbook indicated in the formula, and press F9 to refresh the formula. You can also work around this issue by using SUM and IF functions together in an array …
DSTDEV function - Microsoft Support
This article describes the formula syntax and usage of the DSTDEV function in Microsoft Excel. Estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify. DSTDEV (database, field, criteria)