I have a data dump which has Servers (AMEWEW1ECCS01 being one) as headers and dates in column A. Then values are populated throughout the table for each date in each server.
This Table is named Oct and each column name is the server name, as in Oct[AMWEW1ECCS01]
I need to sum all values in the Oct table that are between a date range and for a specific server. This date range is defined by the [To] & [From] columns in another Table. The below works perfectly if I manually tell it which server it is.
Now I need to make the formula look at a cell in a column called [Server] and populate the Sum_Range accordingly. So replacing the red bit below to reference whatever is in the [Server] column. Any thoughts