We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Help with your formula is missing a parenthesis excel 2003 error
Options

DaveG247
Posts: 399 Forumite


in Techie Stuff
Trying to find and replace something in a formula in excel 03, I need to replace this
=Sumproduct(1*'G
with =Sumproduct(1*('G
However everytime I try I keep getting this error "Your formula is missing a parenthesis--) or (,Check the formula, and then add the parenthesis in the appropriate place"
Anyoe know how I can get round this? I know I could just type in the changes bt I would need to change it 200+ times
=Sumproduct(1*'G
with =Sumproduct(1*('G
However everytime I try I keep getting this error "Your formula is missing a parenthesis--) or (,Check the formula, and then add the parenthesis in the appropriate place"
Anyoe know how I can get round this? I know I could just type in the changes bt I would need to change it 200+ times

0
Comments
-
It's because you only changing part of the formula and introducing an extra bracket. Can't you manually change the formula once than then copy and paste it to the other 199+ cells?Never let it get you down... unless it really is as bad as it seems.0
-
The problem is that your F&R is inserting an extra (, and nowhere along the other end are you adding the matching ).:heartpuls Mrs Marleyboy :heartpuls
MSE: many of the benefits of a helpful family, without disadvantages like having to compete for the tv remoteProud Parents to an Aut-some son
0 -
Thanks, I could copy it but the problem is that the end of the formula's different for each cell, so unfortunatly that wouldn't help am afraid.0
-
You'd probably need code to replace the entire formula with a new one in each cell.
Can you post an old version of the formula and a new one with highlighted of each that are going to change?:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0 -
Thanks, I could copy it but the problem is that the end of the formula's different for each cell, so unfortunatly that wouldn't help am afraid.
I'm surprised that you've got a spreadsheet with over 200 cells totally different (but similar) cells that can't be cut and pasted. Could you post the formulas of two adjacent cells.Never let it get you down... unless it really is as bad as it seems.0 -
The formula I have is this
=Countif('G:\Time Sheets\Dave Goodhand\[Timesheet Period Ending 010511 DG.xls]Week 2'!A1:U69,"AD02")
but to make it work I need to change it to this
=SUMPRODUCT(1*('G:\Time Sheets\Dave Goodhand\[Timesheet Period Ending 010511 DG.xls]Week 2'!A1:U69="AD02"))
I've manged to use find and replace for =sumproduct = instead of , but I still need to get the 1*( and the final ).
Its the ="code" that would change for every cell.0 -
You could try initially replacing all your = characters with something else (e.g. &). Then make your desired changes, and finally change the &'s back to ='s.Stompa0
-
1) Replace =countif with countif
2) Replace ) with ))
3) Replace countif with =sumproduct(1*0 -
1) Replace =countif with countif
2) Replace ) with ))
3) Replace countif with =sumproduct(1*
I've given this a go and I get the another error telling me there's a problem with the formula am afraidYou could try initially replacing all your = characters with something else (e.g. &). Then make your desired changes, and finally change the &'s back to ='s.
This might be a good idea will give it a go on Tuesday when am back at work thanks0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards