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
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 :(
«1

Comments

  • LucianH
    LucianH Posts: 445 Forumite
    Part of the Furniture 100 Posts Name Dropper Photogenic
    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.
  • Tigsteroonie
    Tigsteroonie Posts: 24,954 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    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 remote

    :) Proud Parents to an Aut-some son :)
  • DaveG247
    DaveG247 Posts: 399 Forumite
    Part of the Furniture 100 Posts Combo Breaker
    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.
  • rmg1
    rmg1 Posts: 3,159 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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.
  • LucianH
    LucianH Posts: 445 Forumite
    Part of the Furniture 100 Posts Name Dropper Photogenic
    DaveG247 wrote: »
    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.
  • DaveG247
    DaveG247 Posts: 399 Forumite
    Part of the Furniture 100 Posts Combo Breaker
    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.
  • Stompa
    Stompa Posts: 8,375 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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.
    Stompa
  • john87_2
    john87_2 Posts: 71 Forumite
    1) Replace =countif with countif
    2) Replace ) with ))
    3) Replace countif with =sumproduct(1*
  • DaveG247
    DaveG247 Posts: 399 Forumite
    Part of the Furniture 100 Posts Combo Breaker
    john87 wrote: »
    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 afraid
    Stompa wrote: »
    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.

    This might be a good idea will give it a go on Tuesday when am back at work thanks
  • Stompa
    Stompa Posts: 8,375 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    DaveG247 wrote: »
    This might be a good idea will give it a go on Tuesday when am back at work thanks
    John87's solution and mine were variations on the same idea, so if his doesn't work I think it's unlikely mine will.
    Stompa
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.