You are reading a single comment by @Chalfie 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.
@Chalfie
I have no lookups. It is just coutnifs. I have to export from three sources. Then build something that reports across all three. In this way I should be able to plonk data from each source into its own sheet, have calculation sheets look at the respective sheets, pull those counts into graphs and a summary table.
This is only temporary until the data sources are sorted out and it all comes out of one pipe. I tried the offset and it mucked up the calculations. It was nearly home time, so I'll look again today.