Assume a matrix like data layout where Site’s are mentioned in range C2:C15 and first day of every month from January 2011 till April 2012 are mentioned in range D1:S1. In range D2:S15, the numbers represent the value of the electricity bill received in that month. Some cells can be blank representing bills not received in that month.
One may want to apportion the value of bills received equally over months for which bills were not received. The assumption in doing so is that if a cell in empty i.e. bill not received in the month, then it will be included in the next bill. The problem also is that there can be a variable number of empty cells between various bills received.
You may refer to the “Result” sheet in the this workbook.
Apportion a number over empty cells
{ 10 Comments }