Hi Mynda could you help?

Hi rathanak,

Whenever there is no answer, this may mean that the subject is not clear enough, it's a good idea to come up with more details and an example file, with a manual result based on the scenario described. A clear description of the problem, with sample file and with a manual example of the desired result will always get faster responses.

See the attached file. You've seen and received similar solutions before, so I guess you should be able to make the adjustments if needed.

L.E: The file fails to upload, you have an image of the formulas, just type them on your file and adjust the references.

Cheers,

Catalin

Thanks Catalin, i have sent my file to mail my excel online training hub coz i cant upload here.

Hi Rathanak,

I haven't seen any email from you arrive. 

What browser are you using?  Please try a different one and see if you can attach the workbook with that.  I have no issue attaching documents to this topic.

If you still can't attach a file, please open a Helpdesk ticket.

Regards

Phil

Thanks,Phil

I sent to you by mail please kindly check and correct 

Regards 

Here is Raths' file he sent via email.

Hi rathanak

The formulas in your file seems inconsistent, especially columns H, N and O. Even the values in E35:G39 is not what you described in post #1.

From your question I can only take a guess that you wanted to sum column P (Total Amount Received) for year 2014 in column B (Series).

If that is what you want, then you can try =SUMIF(B5:B21,O25,P5:P21)

Sunny

Thanks sunny,E35:G35 is just criteria it means if motor series 2016 rental cost $18,repair 15,oil 11 and so on

I just want you check my formula wrong or right as I don't use round or not round 

Hope you see

Sorry, I forgot to mention =SUMIF(B5:B21,O25,P5:P21) where O25 in your year e.g. 2014.

Sunny, I don't want to sum by year,i want you to check column N and O I see difference amount as I don't round and round.in practice I want 2 decimals.in column H as I round it is wrong in column I for value 

Hi rathanak your post did require for the total received in 2014.

"Query  if i rent motor series 2014 how can i calculate total amount received if his actual working days only 19 days, withholding tax is 10% on rental? "

I don't quite understand your question. Please give an example of what you want.

Total amount received I Cal already Cell P22.the problem is col total repair per Mon and total oil per month in each cell I need to ask what difference if use round and not round.note I need only 2 decimals

From your data, there are no differences whether you round them or not.

Normally I would round if the formula involves a division.

Thanks, sunny