Hi there,

I am trying to figure out how to add values from different columns on the same worksheet, when the rows don't align.

I want to add the quarterly revenues for each company to get an annual total, but some companies have closed or opened so the rows are misaligned throughout each quarter.

Is there a lookup formula that I could use so that I would be able to add the revenue for each company's quarter without having to manual select the cells in a SUM function?

I hope someone can help me out!!

Thanks so much!