# bathroom

1. ### Using wildcard (*.*) in an excel formula

Hi I hope someone can help me on this. I have a spreadsheet similar to the following Room Location Unit Room Name Surveyor Needed Upstairs 2 Bathroom: Shower Tray 0 Downstairs 3 Bathroom: Tap 0 Upstairs 4 Attic...
2. ### Summarising totals

Hopefully a straight forward answer to this one... How do I get the totals for items that are the same in each column totalled. Need 1-2 (4.308+4.274), 3-11, 12-13 etc. I know it's easy to do it based on the sample below, but I've got tons of pages of data like this...
3. ### IF & AND question?

Hi all, In my excel sheet I am putting in quantities of apartments, there may be a few hundred apartments per complex. Column A will be the unit no., column B number of bedrooms, column C no of bathrooms, etc. e.g. A , B, C, 101, 2, 1, 102, 1, 1, 103, 3, 2, It may take 4 hours to clean a...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back