First of all i want to apologize for my bad English.
Here is the project that i need help with http://img208.imageshack.us/img208/5071/image1xgd.png ,, i need that the value i enter in column P be multiplied by two and then added to the Ukupno sheet column C. http://img41.imageshack.us/img41/417/image2qns.png
I would be really grateful is somebody could provide me with the formula i need.
If needed i will upload .xls on another site because it's 12MB large
First, welcome to the forum!
Your first .jpg is too small to read, so that can't help.
Try zipping your Excel file (after making a copy and deleting any confidential information) and uploading that.
All names were deleted.Once again i need the formula which will multiply(*2) the values that the person (in this case SOME1SOME1) writes to the P column in Tabela nalozi, and then the multiplied value needs to be added to Ukupno sheet(A28 column C). You will see that the formula already exist, but it only calculates the sum of all entered values(by SOME1SOME1).
Hope you will be able to help me!
Without joining mediafire to get your file, I am just asking, can, for instance, SOME1SOME1 appear more than once in the list of names, so what you want to do is:
1) get the sum for all the values associated with when SOME1SOME1 appears
2) multiply that by 2
3) show that final value in the other sheet next to the name SOME1SOME1?
Thats what i want, but that the final value appears in the sheet Ukupno. Here is the current formula =SUMIF('Tabela nalozi'!$D$3:$D$65535,Ukupno!A28,'Tabela nalozi'!$P$3:$P$65509). Name in the sheet Tabela nalozi appears when you type in code given for your name(in this case SOME1SOME1 is H8).You would better understand if you downloaded the system.xls on mediafire. (no viruses in it)
This should be easily done using the inbuilt scripts in excel.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!