Hi, I have in Row A a list of products all with different names. I want to sumif the total sales value of those items referencing the data sheet. It looks like this. =SUMIF(Profitability!$A$2:$A$875;"AH PLUS EXPORT";Profitability!$C$2:$C$875) Is there a way to drag the formula down while excel automatically picks up what the name change is in the reference cell? Ie AH PLUS EXPORT then changes to AH PLUS EXPORT 2 etc
Solved by D. W. in 18 mins