NadoDude
Board Regular
- Joined
- Jun 24, 2010
- Messages
- 84
What would I put into this array formula
{=SUM(IF((Assignments!$H$2:$H$3008=$A45)*((Assignments!$P$2:$P$3008>=($L45))+(Assignments!$P$2:$P$3008="")>0),IF(Assignments!$P$2:$P$3008="",$M45+1,IF(Assignments!$P$2:$P$3008>($M45)+1,($M45)+1,Assignments!$P$2:$P$3008))-IF(Assignments!$L$2:$L$3008>=$L45,Assignments!$L$2:$L$3008,$L45),0))}
if I don't want it to calculate the row if column L is blank?
{=SUM(IF((Assignments!$H$2:$H$3008=$A45)*((Assignments!$P$2:$P$3008>=($L45))+(Assignments!$P$2:$P$3008="")>0),IF(Assignments!$P$2:$P$3008="",$M45+1,IF(Assignments!$P$2:$P$3008>($M45)+1,($M45)+1,Assignments!$P$2:$P$3008))-IF(Assignments!$L$2:$L$3008>=$L45,Assignments!$L$2:$L$3008,$L45),0))}
if I don't want it to calculate the row if column L is blank?