Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
All respected fellows,
When i copy past desired quantity in Qty row, (File attached) It shows error in "K" Cells (#VALUE!) & those cells which Qty Column forum.ozgrid.com/index.php?attachment/55050/ are not blank does not show error. (I want, without Qty, Cells should remain blank)
Please guide me how can I resolve/fix this.
Always regards
Desperately Waiting.
Re: After Copy Past shows Error. (#VALUE!)
khanjee
Welcome to ozgrid.
It gives the error because there is nothing to subtract, you need to put in an IF statement.
This will check the cell in QTY column for a value if no value found will return nothing =IF(E11="","",E11-F11-G11-H11)
Windy
Re: After Copy Past shows Error. (#VALUE!)
Windy58 ,
Many thanks for your help / guidance. It's working.
regards.
Re: After Copy Past shows Error. (#VALUE!)
You are welcome
Windy
Re: After Copy Past shows Error. (#VALUE!)
Hi Windy58 ,
I hope you will be fine.
again here because i have again problem. ( i am again attaching the sheet)
every thing is working perfect fine. problem rises when,
suppose i received Qty (20) when i "copy past" different consumed Qty in column "G" (MC03 Multan) it again show error (#VALUE!) against those columns which are blank and also same error at the end in Summery forum.ozgrid.com/index.php?attachment/55145/.
Please check the sheet/Formulas and correct / guide as possible.
(Windy58, i am not a expert of excel , so dont feel bad due to my questions and my poor English)
Always regards
Waiting.
Re: After Copy Past shows Error. (#VALUE!)
Have made some adjustments to the formulas.
Changed the formulas in the balance column and the summary columns
Is this what you want?
Windy
Re: After Copy Past shows Error. (#VALUE!)
Hi Windy58,
file attached as discussed.
Re: After Copy Past shows Error. (#VALUE!)
Not sure how you are getting one with the VALUE but one suggestion for cell DE15 and others in summary
You can use
=SUMIF($E$8:$CW$8,DE$8,$E15:$CW15)
instead the SUM(,,,,)
Re: After Copy Past shows Error. (#VALUE!)
khanjee
Can you tell me what the problem is that you have, as the calculations seem OK to me.
Windy
Re: After Copy Past shows Error. (#VALUE!)
i have only a little issue,
In Column E, Count 119, Numerical Count 21 (When I select E-11 to E-133), that's fine, But,
When I select the Summery DE Column, it show Count 123, Numerical Count 123 ? (Why show Numerical Count 21)
This is the problem,
Regards.
Re: After Copy Past shows Error. (#VALUE!)
khanjee
I don't know why this is happening.
I tried =COUNTIF(DE11:DE133,">0") and this returned the same as column E. (Numerical count 21)
What do you mean by Count 119?
Windy
Re: After Copy Past shows Error. (#VALUE!)
Count & (Numerical count 21), it is office 2007, option.
Open any excel sheet , at the end of right side, right corner,
Right click there and you will find this .?
Windy58, if not happening, that's OK,
i am fine ,
again many many thanks,.
Re: After Copy Past shows Error. (#VALUE!)
khanjee
I have discovered the answer.
You have got the spreadsheet set up not to show a zero value, when you highlight the range it will count these even though you cannot see them.
See attachment, I have added If statements to return blank in stead of zero.
Windy
Re: After Copy Past shows Error. (#VALUE!)
So nice , so sweet,
I can only say, JAZAK ALLAH.
(I will give you comments after check the sheet)
My vote for Windy58. :rock::thanx:
Always Regards.
Re: After Copy Past shows Error. (#VALUE!)
Thank you, glad to of been of help.
Windy
Don’t have an account yet? Register yourself now and be a part of our community!
