Hi
I have this workbook where the formular in C4 almost seams to work. My probem is, that the same article could go again serval time (D) and I only want to show this number once. It dosent matter if it shows in C4 or C7 but only ones and I can?t figure out the formular for this?
Could someone help me with the last pcs. of a foumular?
Last edited by Vibov; 10-13-2022 at 08:10 AM.
It is not clear what you want as a result your formula in c4 would produce the same result in c2:c3 as well
you can add a if statement if(countifs(d$1:d2,d2,)=1,SUMIFS('omformer lager'!D:D,'omformer lager'!A:A,D4,'omformer lager'!E:E,"<>5650",'omformer lager'!E:E,"<>5660"),"")
but is does not answer the value appearing in c2&c3
Administrative Note:
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Davsth
Thanks for your comment. I'll try to explaint more in details.
I'm trying to make a formular in C, that look at the material number and execute my formular in the last cell in C for each new material number.
As you can see, the material number could have 6 or 9 lines and I only want the count once for each material number, but the formular should be able to do this so I could have the same formular i all cells in column C.
It?s difficult to explain, but I hope you get my point?
As the title appears to have been changed to "sumifs if the right contitions are meet" I'll attempt to help.
The following formula could be pasted into cell C4:Formula:
Please Login or Register to view this content.
Once the formula is in cell C4 press the Ctrl and c keys then select cell C7 and press the Ctrl and v keys, select cell C10 and press the Ctrl and v keys and so on with all cells in column C corresponding to Produktion in column A.
To get a formula for all cells in column C I feel that we will need explanation as to how 504 is selected for cell C3, 96 is selected for cell C9 etc.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks