Forum Discussion
Return the sum of formulas that contain a name
I have a spreadsheet where I have named cell N2 "STR" for Sales Tax Rate. Then I use STR in multiple formulas throughout the spreadsheet. Is there a way to search the spreadsheet for formulas th...
Mr. Curry
pls see attached file.
I hope you can come up with something out of it.
thanks..
if you can give me the formula - I could change the criteria to search for that formula and add them accordingly..
if what I just understood from your explanation is right, it is much complicated than I thought. That being said, I think the simplest way is to name the cells then sum it.
to select non-contiguous cells you may use Ctrl + mouse click all the selected cells then name it. say, the cells name is "curry", in the designated cell, enter =sum(curry) - that's it.
sincerely hope that this helps....thankspls see image..
thanks
