Hello-
Is there anywhere that lists Excel 2003 formulas or perhaps the proper way to write backwards compatible formulas?
I have a sumif formula and a couple others that aren't working in Excel 2003 even though Microsoft Excel hep pages said sumif would work in 2003.
Last edited by jumonjii; 04-16-2014 at 10:45 PM. Reason: Cannot duplicate problem.
Hi jumonjii,
SUMIF function supported in Excel 2003. SUMIFS doesn't.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Ok... so mine doesn't seem to work in 2003 but works in 2007. Any ideas? Like do advanced sumif formulas not work?
I modified your title slightly to be a bit more descriptive.
I have used sumif() in 2003, but as AlKey says, sumifS() wont work in 2003, nor will any of the other functions that have an "S" tacked onto the end...sumifS, countifS etc.
What exactly does your formula and data look like?
Are you sure the "numbers" are actually numbers and not texty that just looks like a number (text with =isnumber()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello-
Maybe I should be using a different formula...
The formula is:On the other sheet, g11:g30 is a code letter. k34:k44 is a list of the different codes and M11:M30 is a dollar value associated with each code.
Please Login or Register to view this content.
On a different sheet I have a range of cells associated with each code and want a total for each one used, if used, for the year.
is K34 on Other Sheet?
SUMIF('other sheet'!$G$11:$G$30,'other sheet'!$K$34,'other sheet)'!$M$11:$M$30)
SUMIF('other sheet'!$G$11:$G$30,'other sheet'!$K$34,'other sheet'!$M$11:$M$30)
Remove ) maybe then it will work
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
No, K34 is on the sheet with g11:g30Originally Posted by FDibbins
k34:k44 are all the different codes.
On a different sheet each cell is suppose to sum the totals for each code.
E.G.
A1 would sum k34
A2 would sum k35
and so on.
I am out of time right now (and only have 2007 here right now anyway). I will be able to take another look at this in an hour or so (and will have 2003), so can you post a small sample workbook?
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Sorry, I typed it in wrong. The SUMIF you posted with the ) removed is what I have.
Sample workbook here.
The formula in N12 of All Forms appears to be correct and working. Saving the workbook produces an error that has to do with formatting supposedly outside of the range of rows and columns for this version of Excel.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hmmm... the person who reviewed it uses Excel 2003. They said that there is nothing in any of the fields on the All Forms sheet. Very confusing.
I get a 'minor loss of fidelity' error about formatting which isn't a big deal. I can fix some of that when I get to work and poke around since we have Excel 2003 there. I'm able to check some stuff but I can't "work on it" so to speak.
I opened your WB in 2003 and, if you mean the sumif() functions on sheet All Forms, they work just fine.
(I would, however, suggest that you try to avoid the use of merged cells, they cause all sorts of problems with formulas)
I also just opened in in 2010, and that is working fine too
I found a copy of excel 2003 and did see that the formulas work as well.
It's weird that it isn't working for the person I sent it to. Will have to double check what happened.
Thanks for checking for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks