LinkBack URL
About LinkBacks
I have the below formula and i keep getting the error missing parenthesis
can anyone help?
=+IF(MATCH($C40='EDGE Data'!$P2:$P5000,'EDGE Data'!P2:P5000 ,0, SUMIF('EDGE Data'!$V$2:$V$5000,2,'Edited Data'!$E$2:$E$5000)
thank you for the help in advance
I have the below formula and i keep getting the error missing parenthesis
can anyone help?
=+IF(MATCH($C40='EDGE Data'!$P2:$P5000,'EDGE Data'!P2:P5000 ,0, SUMIF('EDGE Data'!$V$2:$V$5000,2,'Edited Data'!$E$2:$E$5000)
thank you for the help in advance
Welcome to the forum.
What are you trying to do with this formula? It is completely incorrect. Please explain in WORDS.
Are you REALLY still on Office 97?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
i have 3 columns
Values Totals Key
oh132 26.5 1
oh3254 26.5 1
oh34534 22.5 2
oh2523 21.5 3
i am trying to produce a formula that will add up the totals of each key if i enter an exact match to the values in a cell
So if i typre the value oh132 it will add the totals on anything that has a number 1 in the key
I think you need SUMIFS, but I need to know which version of Excel you are using, please.
There are instructions at the top of the page explaining how to attach your sample workbook.
Keep getting a message that the file size is too large
i have attached an example sheet to better explain what it is i am trying to do
please see file attached
what i am trying to do is match invoice numbers in the Data tab against whatever is typed into the invoice column in the recon tab
the formula needs to match the number then check the day is correct then total up anything in the paid column and add it to Mondays column these steps would then be repeated for Tuesdays and so on
You still haven't said which version of Excel you are using. Please tell us.
Cant find the face palm..damit.
Iv broken away for the weekend now so cant check but im pretty sure its office 97
I don't see any columns labeled Values, Totals or Key nor do I see any entries that look like oh132 in the file attached to post #6.
I am pretty sure you are not using Excel 97 as the .xlsx file format was introduced with the 2007 version (prior to that Excel used the .xls file format).
As for the formula, I feel that it could read (as Ali suggests):Formula:
=IFERROR(SUMIFS('Edited Data'!$E$2:$E$5000,'EDGE Data'!$V$2:$V$5000,2,'EDGE Data'!$P2:$P5000,$C40),"")
As there is nothing in columns P nor V of the EDGE Data sheet I can not test. It would also be helpful to see at least one manually calculated result with which to compare the result of the formula.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks