Hello,

I found a solution .. I used this formula : =IF([REPORT.xls]Project1!H3<>"","not requested",IF([REPORT.xls]Project1!I3<>"","absent"," ")) ... now the problem is that at the end in AJ column I have to count the number of aparitions of "not requested" and "absent" values .. the issue is that a counta formula it caounting the empty cell too ... Ex : in AJ2 it shows 31 when it should be only 5 ...

Thx,
Nedy