Hi there,
I have this formula:
=IF(All!C1="Employees",SUMIF(D2
25,1,$B$2:$B$25)/(SUMIF(D2
25,1,$B$2:$B$25)+SUMIF(D2
25,2,$B$2:$B$25)),SUMIF(D2
25,1,$C$2:$C$25)/(SUMIF(D2
25,1,$C$2:$C$25)+SUMIF(D2
25,2,$C$2:$C$25)))
I'd like to drag this accross columns in one sheet, but would like the highlighted reference to change in row number only.
So, for example:
Sheet 1:
A1: =IF(Sheet2!C1="Employees",SUMIF(D2
25,1,$B$2:$B$25)/(SUMIF(D2
25,1,$B$2:$B$25)+SUMIF(D2
25,2,$B$2:$B$25)),SUMIF(D2
25,1,$C$2:$C$25)/(SUMIF(D2
25,1,$C$2:$C$25)+SUMIF(D2
25,2,$C$2:$C$25)))
A2:=IF(Sheet2!C2="Employees",SUMIF(D2
25,1,$B$2:$B$25)/(SUMIF(D2
25,1,$B$2:$B$25)+SUMIF(D2
25,2,$B$2:$B$25)),SUMIF(D2
25,1,$C$2:$C$25)/(SUMIF(D2
25,1,$C$2:$C$25)+SUMIF(D2
25,2,$C$2:$C$25)))
A3:=IF(Sheet2!C3="Employees",SUMIF(D2
25,1,$B$2:$B$25)/(SUMIF(D2
25,1,$B$2:$B$25)+SUMIF(D2
25,2,$B$2:$B$25)),SUMIF(D2
25,1,$C$2:$C$25)/(SUMIF(D2
25,1,$C$2:$C$25)+SUMIF(D2
25,2,$C$2:$C$25)))
I tried changing it to:
A2:=IF(Sheet2!$C2="Employees",SUMIF(D2
25,1,$B$2:$B$25)/(SUMIF(D2
25,1,$B$2:$B$25)+SUMIF(D2
25,2,$B$2:$B$25)),SUMIF(D2
25,1,$C$2:$C$25)/(SUMIF(D2
25,1,$C$2:$C$25)+SUMIF(D2
25,2,$C$2:$C$25)))
But this did not work.
thanks for any help,
Neil
I have this formula:
=IF(All!C1="Employees",SUMIF(D2
I'd like to drag this accross columns in one sheet, but would like the highlighted reference to change in row number only.
So, for example:
Sheet 1:
A1: =IF(Sheet2!C1="Employees",SUMIF(D2
A2:=IF(Sheet2!C2="Employees",SUMIF(D2
A3:=IF(Sheet2!C3="Employees",SUMIF(D2
I tried changing it to:
A2:=IF(Sheet2!$C2="Employees",SUMIF(D2
But this did not work.
thanks for any help,
Neil