2014-04-21 7:35 GMT+05:30 Purushothaman M <[email protected]>: > hai > > i am taking my section electrical energy meter daily and > entering in a worksheet in one cell. in the next cell cumulative > energy consumption for the month is calculated manually. is there any > formula to calculate automatic cumulative energy consumption for a > month(or for a quarter) and getting reset after every month so that > error due to manual addition can be eliminated. regards. >
Based upon my understanding of your Problem, My suggestion is as below: Suppose you have two rows of data, the formula is as in N2 D1 M1 N1 D2 M2 N2 = if(month(D2)==month(D1),M2 + N1, 0) Where D -- Date, M -- Meter Reading N - Cumulative In case you are expecting something different, please mail me off the list with your exact requirements (with Sample Calc Sheet, ofcourse!!!) -- Regards, ARUN P *A Tailor’s mistake is a Fashion But, An Engineer’s mistake is a Disaster.* "Preserve the earth; Else we will perish" _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
