What about a simple CASE statement, will dat do the trick?

Declare @firstno varchar(10) = 'V001',

@scndno varchar(10) = 'V005'

select count(*) from #tbl WHERE number between @firstno and @scndno

select count(*) from #tbl WHERE number between @firstno and @scndno and numstatus = 'Active'

select

case when

(select count(*) from #tbl WHERE number between @firstno and @scndno)

=

(select count(*) from #tbl WHERE number between @firstno and @scndno and numstatus = 'Active')

then 'Active serie'

else 'One or more values are not Active'

end as result