We’d like to remind Forumites to please avoid political debate on the Forum.

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.

📨 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!

The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

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…

Comments

rmg1 Posts: 3,159 Forumite

26 May 2011 at 8: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