Hi Zahid
Attached file is an extract of the main file. The formula I am trying to sort is at row 405/406. Trying to get a sum of all items from the table that are in the appropriate mth and day/night per column C and row 380.
As I download rows 1-374 from a utility company I'm trying to avoid putting the day/night at the top when I could then use a pivot table to do the same thing.