ADVERTISEMENT
kelly1 said:I am using this simple formula and getting #VALUE! error.
Can anyone suggest a solution please.
=I8+O8+U8+AA8+AG8+AM8+AS8+AY8+BE8+BK8+BQ8+BW8+CC8+CI8+CC8+CU8+DA8+DG8+DM8+DS8+DY8+EE8
Thanks for any help
Kelly
kelly1 said:Yes I do have formulas, but it did work before up to 15 additions, then I extended it to 22 and am now getting problems.
Examples
=IF(ISERROR($I$1),"",SUMPRODUCT(--('User 01'!$N$3:INDEX('User 01'!$N:$N,$I$1)>=$G8),--('User 01'!$N$3:INDEX('User 01'!$N:$N,$I$1) < $G9),--('User 01'!$M$3:INDEX('User 01'!$M:$M,$I$1)=I$7)))
=IF(Totals!$H$17<1,"",SUMPRODUCT(--('User 01'!$I$3:INDEX('User 01'!$I:$I,$J$1)>=$G8),--('User 01'!$I$3:INDEX('User 01'!$I:$I,$J$1) < $G9)))
.