I've got absolutely no idea where to start with this so I thought I'd come here and ask the gurus!
So I have a sheet full of sales forecasting data that I want to be able to lookup a sales forecasting stage such as Pipeline, Development, Legal, Close etc and then go through the data, pull out all the Pipeline opportunity values by QTR and add them together in a summary:
Q1 Pipeline = xxxx
Q1 Sol Dev = xxxx
Q1 Legal = xxxx
Q1 Close = xxx
Q2 Pipeline = xxx
I'm thinking it might be a VLOOKUP but honestly I have no idea!