I now have three worksheets
Cover - the glossy view of sums
data - raw data of job entries
monthly - monthly budget for jobs
xhour - hours spent on each job
the question is I would like to fill a cell on Cover with the sum of all hours in xhour but the kicker is need to do it by segment. There is a one to one corelation between job ids in xhour and monthly but on monthly there is a column called segment.
So for segment = walmart match all soebel IDs from Monthly to xhours and sum hours.