Forum Discussion
=Count.ifs Multible factors
Hi, I have an issue with =Count.Ifs formal. I'm using an Excel sheet where all values in columns are based on =VLookup based on factor in coulumn A. I need to get a summary of the content in ...
OliverScheurich Thank you for this, I'm trying to adopt and use the same format, but when the factors and master excel are above 2000 items its not function.
I have to teach myself how to use power query properly.
Thank you!
You are welcome. In order to get started with Power Query i'd recommend this site: