redbarn1827
New Member
- Joined
- May 9, 2015
- Messages
- 15
Hi,
I am using the following formula which i need to copy across columns, however as I copy I wish the WAR12 to increase incrementally by 1 each time, is there any way I can do this without manual edit.
{=SUM(IF(General!$P$6:$P$4585="<wbr style="color: rgb(0, 0, 128); font-family: Arial; font-size: 14.6666669845581px;">WAR12",IF(General!$AB$6:$AB$<wbr style="color: rgb(0, 0, 128); font-family: Arial; font-size: 14.6666669845581px;">4585="PART",1,0),0))}
Thanks in advance
I am using the following formula which i need to copy across columns, however as I copy I wish the WAR12 to increase incrementally by 1 each time, is there any way I can do this without manual edit.
{=SUM(IF(General!$P$6:$P$4585="<wbr style="color: rgb(0, 0, 128); font-family: Arial; font-size: 14.6666669845581px;">WAR12",IF(General!$AB$6:$AB$<wbr style="color: rgb(0, 0, 128); font-family: Arial; font-size: 14.6666669845581px;">4585="PART",1,0),0))}
Thanks in advance