Thanks for that.
Can you do it for multiple criteria..?
I want now to total all of the information up with "build1" and once it has done that to count the number of desks that that have "vacant" in the field.
e.g there are 60 fields with "build1" but only 20 of them have "vacant" in another column..
Can anyone help?
Can you do it for multiple criteria..?
I want now to total all of the information up with "build1" and once it has done that to count the number of desks that that have "vacant" in the field.
e.g there are 60 fields with "build1" but only 20 of them have "vacant" in another column..
Can anyone help?