Forum Discussion
Solved
SUMPRODUCT() Formula Query
Hello, I'm facing issue while using SUMPRODUCT(). I have 2 different table (TableX and TableY). TableX = Contains Department, Candidates and Joining Date TableY = Department, Candidates and New...
In general formula works
Please check attached
You might create a pivot table based on the first table.
Add Department ID to the Rows area, Joining Date to the Columns area and Candidate Name to the Values area. Group the Joining Date by Months (and Years if applicable).