Originally Posted by
Bo_Ry
Why do you manually add blank rows when formula from Post#2 already gives the result? Instead of keep changing this and that, Please provide the sheet with the final expected result.
My requirement is that I have an ESTIMATE sheet and RATE sheet
The Final Rate field (obtained by rounding off Amount values/ sum of few amount values as the case may be) from the RATE sheet are required to be matched to the ESTIMATE sheet by referring to the Sl. No field. Initially, my requirement was to get final rate corresponding to the Sl. No from the DATA sheet which was served by following user-defined function entered in Cell I5 of Rate field of ESTIMATE sheet.
Later, I wished to get the Final Rate field in RATE sheet also automated for which I used the following in Cell K2 of Final Rate in RATE Sheet
However, I observed that the values of Final rate in RATE sheet which are obtained by summing values in Amount Field of RATE sheet are not matched in ESTIMATE Sheet. Hence, in the ESTIMATE Sheet, Item 2.1, 3.0 and 4.0 are blank and not reflecting the Final Rate (in RATE Sheet); 44,081.00 , 2,408.00 , 513.00 respectively.
I also thought user defined function would be of help. Hence, I tried GetRoundupSum in Final Rate field of RATE Sheet, which was not returning the correct sum.
I apologise for posting the problem many times as I was trying to evolve the different cases for my requirement. The worksheet is attached herewith
Bookmarks