[Solved] I need help figuring out what's causing this error

R.Santiago

New member
=IF(A2='Call Out vs Off'!A2,COUNTIF('Call Out vs Off'!E2:Z2,"CALL OUT"),IF(A2='Call Out vs Off'!A3,COUNTIF('Call Out vs Off'!E3:Z3,"CALL OUT"),IF(A2='Call Out vs Off'!A4,COUNTIF('Call Out vs Off'!E4:Z4,"CALL OUT"),IF(A2='Call Out vs Off'!A5,COUNTIF('Call Out vs Off'!E5:Z5,"CALL OUT"),IF(A2='Call Out vs Off'!A6,COUNTIF('Call Out vs Off'!E6:Z6,"CALL OUT"),IF(A2='Call Out vs Off'!A7,COUNTIF('Call Out vs Off'!E7:Z7,"CALL OUT"),IF(A2='Call Out vs Off'!A8,COUNTIF('Call Out vs Off'!E8:Z8,"CALL OUT"),IF(A2='Call Out vs Off'!A9,COUNTIF('Call Out vs Off'!E9:Z9,"CALL OUT"),IF(A2='Call Out vs Off'!A10,COUNTIF('Call Out vs Off'!E10:Z10,"CALL OUT")IF(A2='Call Out vs Off'!A11,COUNTIF('Call Out vs Off'!E11:Z11,"CALL OUT"),IF(A2='Call Out vs Off'!A12,COUNTIF('Call Out vs Off'!E12:Z12,"CALL OUT"),IF(A2='Call Out vs Off'!A13,COUNTIF('Call Out vs Off'!E13:Z13,"CALL OUT"),IF(A2='Call Out vs Off'!A14,COUNTIF('Call Out vs Off'!E14:Z14,"CALL OUT"),IF(A2='Call Out vs Off'!A15,COUNTIF('Call Out vs Off'!E15:Z15,"CALL OUT"))))))))))))))/(COLUMNS('Call Out vs Off'!E2:Z15)))

The goal of this formula is to give me the % that the technician had a "call out" from work
 

Attachments

Online statistics

Members online
1
Guests online
184
Total visitors
185

Forum statistics

Threads
460
Messages
2,044
Members
2,322
Latest member
mmtobnWeaph
Back
Top