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
Also, blanks in your columns could mess it up as the counta in the named range formula may not pick them up.
I think I started you down this track with an idea that large named ranges could slow down the countifs. Apologies if it's a faff. I don't know the size of your data, but it might be worth trying to see if changing the named ranges from F:F to F1:F10000 (or something) actually does speed up your sheet.