Forum Discussion
Site Count
I'd recommend putting all the data into a single database if that's at all possible. Excel works very well and very easily with single databases, sifting and sorting, counting, etc. Unless there's a compelling reason to have multiple tabs, you'd be far better served with a single tab containing all the data.
In this case, too, you want a single column reflecting "Frequency", not three separate ones, one each for Daily, Weekly or Monthly. That enables a single criterion -- Frequency -- to be used in the FILTER function. (By the way, the FILTER function does require the most current version of Excel)
=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