r/excel•
neatelijah38

Data Not Sorting Properly in Table When Using COUNTIF

unsolved

I am trying to develop a table that sorts movie genres that I have watched. I am using the COUNTIFS function to count the total number of films of each genre (referencing a second worksheet), but the data does not sort properly in the table. =COUNTIF(Ratings!$I$2:$L$51,Data!A19) is the formula I am using

https://preview.redd.it/o318mu3wlsye1.png?width=248&format=png&auto=webp&s=c9ef8c432a35577f6f8723869efab403e81da4ad

Posted May 4, 2025, 4:36 PM UTC

16
Loading comments…