I have a SUMIF formula and I need to drag it down and want to increase the value for the column which I believe is referred to as an increment.
The below image shows the format, using the current Olympic Games medal table. Each total is calculated from a SUMIF calculation of winners for each country and as there more than 200 countries competing I want to drag down the SUMIF so that it refers to the next column automatically.
Can anyone suggest a solution?
Thanks.
The below image shows the format, using the current Olympic Games medal table. Each total is calculated from a SUMIF calculation of winners for each country and as there more than 200 countries competing I want to drag down the SUMIF so that it refers to the next column automatically.
Can anyone suggest a solution?
Thanks.