KarlRadaza
New Member
- Joined
- Nov 27, 2018
- Messages
- 14
Hello Excel-lent people,
Very basic issue but i cant seem to figure out why i cant get the results i desire. I just basically need the formula to count the number of data that has the matching month and year. For example on the screenshot ,lets focus on cell Q6, the formula i came up with is:
=SUMPRODUCT(($B$2:$B$24=Q$3)*($C$2:$C$24=$E6))
And i prefer this over countif but trust me it leads to a faulty result of "1" when in fact there is no "Dec 2020" on the array..
And as you can see ,it yields 1 for all which is incorrect, and frustratingly i cant figure it out despite changing the table array referencing. Please help me guys, looking forward to any help and thank you for yalls time! Stay safe all!
Very basic issue but i cant seem to figure out why i cant get the results i desire. I just basically need the formula to count the number of data that has the matching month and year. For example on the screenshot ,lets focus on cell Q6, the formula i came up with is:
=SUMPRODUCT(($B$2:$B$24=Q$3)*($C$2:$C$24=$E6))
And i prefer this over countif but trust me it leads to a faulty result of "1" when in fact there is no "Dec 2020" on the array..
And as you can see ,it yields 1 for all which is incorrect, and frustratingly i cant figure it out despite changing the table array referencing. Please help me guys, looking forward to any help and thank you for yalls time! Stay safe all!