We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

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

DaveG247 · 2011-05-24 11:35:11

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…

Options

Comments

rmg1 Posts: 3,159 Forumite

26 May 2011 at 9:00AM

Can't you list the codes elsewhere and then just refer to the cell that holds the code rather than the code itself?
Assuming your codes are in column K, you could have :-
=SUMPRODUCT(1*('G:\Time Sheets\Dave Goodhand\[Timesheet Period Ending 010511 DG.xls]Week 2'!A1:U69=K1))
That way, assuming your codes are in the right order, you could copy the formula to wherever it was needed.

: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