Hi,
First of all I just want to say that this is the first time I've post something (I think, old account) So If I do something wrong or post in the wrong place, I'm sorry.
I work in construktion and trying to make a excel sheet to keep track of cost. As you can see in line 251 in attached excel file, all I get is ##. Anyone know what I'm doing wrong?
Not sure what information you would need to look at the problem, so let me know and I'll answer the best I can.
Anyways, thanks alot.
Skymarshal.
Hi,
1. what verion of excel are you using? (please updates your profile if needed)
2. what is 'SUMMER.HVIS.SETT' in you formula?
Hi,
1. I use the Office 365 version of Excel.
2. I think this is called SUMIFS in English, SUMMER.HVIS.SETT is the Norwegian name.
It appears that the formula in similar rows; i.e. 217, 225, 234 are pretty simple comparatively.
Note that those formulas reference cells in row 6 which is blank and seem to try to use that as a criteria for column K in the Agresso bilag sheet which appears to contain numbers similar to the ones in row 7.
Is there a reason that the formulas in cells G242 and G251 are more complex than in the rows mentioned above or even the formula in H242?
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
It's difficult for me to analyze the formula because of the different language (my Excel doesn't recognize your formula). However, what you might want to try is to remove a large part of the formula and see if you get a result. If you do, then add more of the formula back in. Continue until you find a small part of the formula that's giving you the error.
As to the formula in cell G251, removing the ( before the equal sign and the ,0) at the end will get rid of the error, although I don't know if it produces the expected result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks