Forum Discussion
Counting
Hi everyone! I'm trying to count how many times an user appears in a data per week, but I can't seem to find the right way to do it. Do you have any suggestion?
2 Replies
=SUMPRODUCT(($B8=$B$2:$L$5)*(C$7=$A$2:$A$5))You can apply SUMPRODUCT for the data layout of the example.
- You could use COUNTIF or COUNTIFS. It's difficult to draw up a formula without the data.
