Can you fill a chart across a column but with the row number changing?
Example: Cell A1 =SUM($E10,$E20,$E30) then Cell B1 =SUM($E11,$E21,$E31)
So after i have cell A1 I can drag the fill handle to the right and the number increase but the letter stays?
Thanks
Bookmarks