[Ilugc] help in libre office/excel
- From: arunpalaniappan.mek@xxxxxxxxx (ARUN PALANIAPPAN)
- Date: Tue, 22 Apr 2014 00:38:45 +0530
2014-04-21 7:35 GMT+05:30 Purushothaman M <lobestar at gmail.com>:
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"
Other related posts: