Return the sum of formulas that contain a name

Question

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 that contain STR and return the sum of those cells?

On my spreadsheet, all of the formulas that contain STR are in column W.

lorenzo kim · Answer

Mr. Currytry these sites:https://www.techrepublic.com/blog/microsoft-office/identify-which-cells-in-excel-are-formula-cells/https://docs.microsoft.com/en-us/office/vba/api/excel.range.findhttps://www.rondebruin.nl/win/s9/win006.htm&nbsp;HTHthanks..

lorenzo kim · Answer

Mr. Currypls see attached file.I hope you can come up with something out of it.thanks..

lorenzo kim · Answer

if you can give me the formula - I could change the criteria to search for that formula and add them accordingly..

lorenzo kim · Answer

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....thanks

lorenzo kim · Answer

pls see image..thanks&nbsp;

Forum Discussion

Return the sum of formulas that contain a name

Share

Resources