try this simpler version where I rewrote the formulas in the c:e and then copied that block to each of the other blocks
Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Lokesh Loki Sent: Saturday, March 24, 2012 11:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: wrong sum total and total time Please do the needful experts. ---------- Forwarded message ---------- From: Lokesh Loki <lokeshsmg2...@gmail.com> Date: Sat, Mar 24, 2012 at 9:43 PM Subject: Fwd: wrong sum total and total time To: rajan verma <rajanverma1...@gmail.com> Hi Rajan, I Need a sum and count formula brother. Before Noorain has given one formula but it's not applicable to the next rows. I have mentioned yellow color cells in that i want formula. Please do the needful. Regards Lokesh.M ---------- Forwarded message ---------- From: Lokesh Loki <lokeshsmg2...@gmail.com> Date: Tue, Mar 13, 2012 at 3:22 PM Subject: Fwd: wrong sum total and total time To: NOORAIN ANSARI <noorain.ans...@gmail.com> Hi Noorain, Please find the excel file and i am facing some incorrect data in this excel file. The cells are yellow marked. check and do the needful brother. Regards Lokesh.M ---------- Forwarded message ---------- From: Marisiddaiah, Lokesha @ Bangalore (Xchanging) <lokesha.marisidda...@cbre.com> Date: Tue, Mar 13, 2012 at 2:27 AM Subject: wrong sum total and total time To: "lokeshsmg2...@gmail.com" <lokeshsmg2...@gmail.com> Regards, Lokesh. M |Advanced Associate Xchanging |Accounts Payable Xchanging Tower | SJR iPark | EPIP Area | Whitefield | Bangalore | 560066 (1-800-920-6957) EXT-1648 lokesha.marisidda...@cbre.com|www.cbre.com --- Be Clean, Go Green --- Please consider the environment before printing this message -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com