You are reading a single comment by @christianSpaceman and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@christianSpaceman
To be honest, I don't follow exactly what you're trying to do, however quantity of data is likely important.
I seen countifs (and sumifs) have a marked effect on spreadsheet calculation times over large (50K+) numbers of rows. I've also seen the increased row count (1m+) in excel 2010 effect memory / performance when it's referenced in formulae, even when when most of it is empty (perhaps your named ranges are very very large - do they span an entire column, then you're countif'ing over that?).
I'd start here, make sure your named ranges themselves aren't massive (perhaps google 'dynamic named range' to limit their size).
If you don't mind if it takes a few seconds to get your data, perhaps you could turn calculation to manual.
Feel free to ask more / pm