Sum of cells based on matched cells

[davehamshaw]

I have a list of users and their mailbox sizes listed in a table. I am also provided with a list of specific users from that list. The task is to add up the total size of those mailboxes for only the people listed. I think it's either SUMIF or SUMIFS but struggling to find a working formula!

Column A lists the users
Column B lists their mailbox sizes
Column D contains a list of specific users

I need a formula to add up the mailbox sizes from Column B but only for the users from Column D.

Hope that makes some sense!

Any help would be appreciated.

Many thanks.

DH

[José Augusto]

Hi
Your 'mailbox sizes' contains text?

[davehamshaw]

It contains numbers, as in GB or MB.

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[davehamshaw]

I tried to attach a file but clicking the paperclip icon just shows a small white menu with no other input on it. I can't even add a screenshot of that to show you! I'll try from another browser.

[TMS]

Read post #4 again … it explains what to do. The paperclip doesn't work.

[davehamshaw]

Apologies, didn't see the last bit, file attached with dumb data.

[KOKOSEK]

into D12:

=SUM(SUMIFS(B2:B10,A2:A10,D2:D6))

accept with Ctrl+Shift+Enter (not just Enter).

[davehamshaw]

That's great! Thank you for your help everyone, that looks to have got it.

[José Augusto]

Or in a usual formula (not an array formula)

=SUM(INDEX(SUMIF(A2:A10,D2:D6,B2:B10),))