S
SharEye
Say i have this in a sheet:
Type | Person | Room
Desktop | James |Room1
Desktop | Chris | Room3
Desktop | Unassigned | Room1
Printer | | Room2
Laptop | Gaz | Room1
and i then want to produce a guid like this:
-------->| Room1 | Room2 | Room3 | Total | Unassigned
Desktop | ? | ? | ? | 3 | ?
Printer | ? | ? | ? | 1 | ?
Laptop | ? | ? | ? | 1 | ?
I can use this
=COUNTIF(A2:A100, "Laptop")
to count the number of time Laptop is listed for example in the firs
colum but how do i search and count desktops in Room1 etc?
I have tried loads of different ways with no luck.
Thank
Type | Person | Room
Desktop | James |Room1
Desktop | Chris | Room3
Desktop | Unassigned | Room1
Printer | | Room2
Laptop | Gaz | Room1
and i then want to produce a guid like this:
-------->| Room1 | Room2 | Room3 | Total | Unassigned
Desktop | ? | ? | ? | 3 | ?
Printer | ? | ? | ? | 1 | ?
Laptop | ? | ? | ? | 1 | ?
I can use this
=COUNTIF(A2:A100, "Laptop")
to count the number of time Laptop is listed for example in the firs
colum but how do i search and count desktops in Room1 etc?
I have tried loads of different ways with no luck.
Thank