I got it to work with the following code:

select type as 'TYPE',

[ARCHIVED] as 'ARCHIVED',

[AVAILABLE] as 'AVAILABLE',

[BUILD] as 'BUILD',

[OPERATIONAL] as 'OPERATIONAL',

[ORDERED] as 'ORDERED',

[RECEIVED] as 'RECEIVED',

[REQUESTED] as 'REQUESTED',

[Retired] as 'Retired',

[TEST] as 'TEST',

[BLANK] as 'NULL',

[ARCHIVED]+[AVAILABLE]+[BUILD]+[OPERATIONAL]+[ORDERED]+[RECEIVED]+[REQUESTED]+[Retired]+[TEST]+[BLANK] as TOTALS

from

(select type, isnull(istatus,'BLANK') as istatus, logical_name

from dbo.devicem1

group by type, istatus, logical_name) p

pivot (count(logical_name)

for istatus in ([ARCHIVED],[AVAILABLE],[BUILD],[OPERATIONAL],[ORDERED],[RECEIVED],[REQUESTED],[Retired],[TEST],[BLANK])

) as DevicePivot

order by type