Basic formulas and functions + more (COUNT, SUM, IF, AVERAGE, COUNTIF, SUMIF, VLOOKUP, MIN, MAX, SUMPRODUCT, MOD, ABS, PRODUCT, SQRT, Named ranges, Paste Special)
-
Updated
Jul 15, 2025
#
sumproduct
Here are 2 public repositories matching this topic...
A formula-driven Excel data cleaning and analysis project that transforms messy, raw HR datasets into an automated department summary dashboard using VLOOKUP, SUMPRODUCT, and conditional logic.
dashboard data-management data-cleaning data-quality vlookup excel-formulas hr-analytics data-standardization excel-analytics sumproduct reporting-automation
-
Updated
Apr 26, 2026
Improve this page
Add a description, image, and links to the sumproduct topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the sumproduct topic, visit your repo's landing page and select "manage topics."