|Tenant||Flat no.||Duration stayed||Energy consumed in flat|
To find out:
|Energy consumed per tenant|
I have to consider the unique value of column
A as an identifier in order to avoid duplicate results/errors in calculations.
A2:A5 stay in the same flat
B2:B5, they have consumed 85KW
D over 30 days
Manual process as per every flat
Formula to automate:
However this formula only works up to a certain range. If I increase the range for column
B, the result becomes incorrect.