Hi Guys,
I cant upload the spreadsheet for some reason so i'll do my best to explain and attach it below if it will let me!
I have a list of data which represents daily Electricity usage on sheet : HH Data.
Column A = Total Day usage for that day
Columb B = Total Night usage for that day
Column C = Total usage for that day
Column D = Date
Column E - AZ = consumption used (in half hour increments from 00:00 - 23:00)
I need to extract data from this sheet and populate the sheet : Sorted Data
The sorted data needs to fill tables with Total Day usage, Total Night usage, and Total Usage.
This needs to be done for Weekly, Monthly and Yearly data.This needs to be done for Weekly, Monthly and Yearly data.
so for monthly data it needs to identify the begining and end of the month and total up the units for each day then return the total
To make things more complicated........
I also need to be able to identify Weekday / Weekend usage.
So i also need it to pull data for Total Weekday usage on a weekly/monthly/yearly bass as well as weekend usage on a weekly/monthly/yearly basis.
I am completely lost as to how to do this.
I cannot just reference the HH data directly because this sheet will be used for different data which will not hold the same dates.
Any help would be greatly apreciated!
Bookmarks