Count certain numbers in column then multiply by sum of other column linked to first.

[jamies01]

Hi all, I am a new member here and have searched the threads, but can't seem to find the solution to my problem.

excel example.jpg

Above is my table. In the cells underneath the "1 Beds", "2 Beds" and so on, I need to show the number that is the total of the number of relevant bedrooms in column B multiplied by the number of that number of bedrooms house types in column C. I've not explained that very well, but for example the "1 Beds" should show 6 - because there are 3 house types with 1 bedroom in column B and 6 of them in column C (2 each of house types A, B, and C).

I know I could just use SUMPRODUCT, but the data in the Columns A, B, and C is subject to change, so ideally i would like a formula which picks up on whatever data is those columns, rather than a fixed formula.

I've tried a couple of different ones that I know, but so far no joy.

Any and all assistance/tips very welcome! Please let me know if you need any further info.

Thanks
Jamie.

[etaf]

=SUMIFS() should do that

your example shows unique house types
so its just a SUMIFS( C:C,B:B, 1)

A sample sheet - with examples of SUM expected and WHY

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[jamies01]

Thanks etaf, that's it! I was trying various IF but not that one, I think i was trying to make it too complicated.

And thanks for the feedback/tips on how to post, i know what to do going forward.

Thanks again for your quick and excellent help.

Jamie.

[etaf]

you are welcome