Forum Discussion
Site Count
I have 10,000 assets listed across 140 sites, each asset have varying frequency. I would like to count the number of sites that each asset type exists on based on there frequency and task type In th...
Thanks mathetes
=COUNT(_xlfn._xlws.FILTER(Table1,(Table1[Site type]=G2)*(Table1[Task]=G3)*(Table1[Frequency]=G4)))
I'm sure I can get this to work in my table as the majority of the data is in the main table, however when I open the sample attached the count does not apper to be working?
Thanks
Andy
=COUNT(_xlfn._xlws.FILTER(Table1,(Table1[Site type]=G2)*(Table1[Task]=G3)*(Table1[Frequency]=G4)))
I'm sure I can get this to work in my table as the majority of the data is in the main table, however when I open the sample attached the count does not apper to be working?
Thanks
Andy
This is the formula as it left me. As noted, it does require the most current version of Excel; do you have that?
=COUNT(FILTER(Table1,(Table1[Site type]=G2)*(Table1[Task]=G3)*(Table1[Frequency]=G4)))
I'm not sure what the "_xlfn._xlws." came from in the version you show.
Here's a link to a YouTube video that explains the FILTER function. https://www.youtube.com/watch?v=9I9DtFOVPIg
- I'm running 2016 so I now see the function won't work unfortunately, back to the drawing board
Thanks Again