COUNTIFS works perfectly well with whole column references. You do not need to repeat the sheet name every time
'Amostra TR'!A:A is correct
'Amostra TR'!A:'Amostra TR'!A is NOT correct
COUNTIFS works perfectly well with whole column references. You do not need to repeat the sheet name every time
'Amostra TR'!A:A is correct
'Amostra TR'!A:'Amostra TR'!A is NOT correct
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
still doesnt work... , now i have: '=COUNTIFS('Amostras NR'!A4:A123,">=0",'Amostras NR'!A4:A123,"<5")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks