Countif

[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

 

[Frank Kabel]

Hi
try using a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

 

[SharEye]

very interesting, thanks very much i will have a play with that