Forum Discussion
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 Column under which I want to populate the count Candidates who will join in specific month.
Below formula is not working. Can someone please help on this ?
=SUMPRODUCT((TableX[Department ID])=A2)*MONTH((TableX[Joining Date])=6)
Table1:
Table2:
In general formula works
Please check attached
5 Replies
In general formula works
Please check attached
Hello SergeiBaklan
Thank you so much for your time and solution. Really appreciate your help!!
Great!! This works.
Thank you!! Thank you!! Thank you!!
You are welcome, glad to help
Hi SergeiBaklan
Thank you so much for taking time to respond to my question. Really appreciate your help.
Great!! This works. Thank you!! Thank you!!
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).
