non-adjacent range

I have data being entered into non-adjacent columns that I want to merge, sum then remove the duplicated name. I do not have a master floor type list to query as there are over 50k types. Example, Floor Tile. There are potentially 5 different floor tile types being entered per row (house) and I...

Hello, I am working trying to get the average of non-continuous cells that are >0. I have looked up this topic and used advice found there previously but I am not getting the results. This is the current formula I am using...

Hi, I would like duplicate a chart and remove some data points to make a cleaner, more presentable version of my original chart. I would like to do this while keeping the original chart and all its data points intact. This way I can see both the refined version and the original version...

I am trying to create a simple formula using the SUM function combined with OFFSET and named ranges as follows =SUM(OFFSET([named range],,2) This appears to work fine as long as my named ranges are contiguous, i.e. (B3:B5) for example; however, as soon as a named range contains non-contiguous...