I used to consider myself advanced in excel but seem to be rusty or this is just not possible. I want to create a named range called "Q1" as criteria to sum Jan, Feb, Mar at every instance of the row criteria, "DMC". The entire data set has all 12 months and multiple lines of data but just using this as an example to simplify. Any help as always, is greatly appreciated.
Thanks.
Cost Code Jan Feb Mar
DMC 100000 75000 85000
Bookmarks