I'm creating a page where the months are in cells A19 to A30. On ROW 18 I have different category headings like B18 is Advertising, C18 is Rent.
so what I'm doing is SUMIF in B19 and I've created the formula with relative cells to look in so my formula would be =SUMIF(Jan!$D$5:$D$94,"Advertising",Jan!$C$5:$C$94) but what I want to change when dragging is the Jan to Feb to Mar etc. All other information and references are working good. I'm doing a find and replace row by row. There must be a way to change the tab (or month) names.
so what I'm doing is SUMIF in B19 and I've created the formula with relative cells to look in so my formula would be =SUMIF(Jan!$D$5:$D$94,"Advertising",Jan!$C$5:$C$94) but what I want to change when dragging is the Jan to Feb to Mar etc. All other information and references are working good. I'm doing a find and replace row by row. There must be a way to change the tab (or month) names.