Hi All,
First post here, apricate the help.
In the attached image, i would like to add a formula to B25 that will look up the word sales in row 24 then get the value from row 25 for the sales column. then add up those numbers. I have done it simply by just adding g25 + k25 but as i add more and more columns to the sheet, i just want it to add this up automatically.
If this need a better explanation, please let me know.
Thanks in advance for the help.
James
excel.PNG
Bookmarks