Counting multiple values across several columns

[TiagoG]

Hello guys,

I've been trying to find a way to solve this issue about counting diferent values across various columns and presenting that in a pivot table.

I've managed to do so with countif support columns but this is very rough and makes the file very heavy since i have 3 more categories with 100+ possible values, so I'm looking at 400 count if columns on a list that grows a lot each day.

The idea is to count how many times each W shows up (w1, W2, W3...) acros all 1W, 2w, etc columns in a pivot table with only the values that show up instead of having all W's and populating a table with zeros.

I hope I've been clear enough explaining what I want to do.

Thank you very much for your time.

[TMS]

Not sure if this helps:

Please Login or Register  to view this content.

[TiagoG]

Hi there,

If I understand right that counts how many w's there are. In fact I need to know how many times each w comes up in the table.

[AliGW]

Are you still using Excel 2010?

[TiagoG]

No. I'm working on 365

[AliGW]

Then please update your forum profile - it's out-of-date. Thanks.

[Glenn Kennedy]

Your requirement is not clear for me, either... but maybe:

=COUNTIF(Tabela1[[1W]:[11W]],S2)

see file for CONTEXT.