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...
pls see if the attached can help.
it will search for formula in the cells and add those with formula (with equal sign)
press ALT F8 and run the macro
thanks..