Sum up cells when option selected

[EUDIS1980]

Hello, could someone help me with creating a formula? I'm not sure if i should use COUNTIF or some logical function.

Column C has numbers and column D dropdown menu with a few options. I want to sum up to some other cell the numbers of column C, but only if a specific option is selected in column D.

Example:

COL CCOL D
5

New

7

Reused

3

Reused

2

New

7

Reused

So i want to sum all the numbers in Col C only if "New" is shown in corresponding cell of Col D.


Thanks!

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(I did it for you as you are new here Please read forum rules AND the yellow banner

[EUDIS1980]

Thank you, Pepe Le Mokko

[AliGW]

Try this:

=SUMIF(D:D,"New",C:C)

[EUDIS1980]

Hi, thanks.

So, for example, you mean SUMIF(C1:C100,"New",D1:D100)? Because this returns "#ERROR"

[AliGW]

It will only return an error if:

1. There is no match, or
2. The numbers in the sum column are actually text.

Attach the workbook so we can work this out.

[EUDIS1980]

Unfortunately i am not allowed to, because i'm new.

[AliGW]

Yes, you are - look at the yellow banner at the top of the page for instructions.

You are not allowed to post links, but you aren't being asked to post a link.

[Pepe Le Mokko]

Perhaps you need to change the commas in ALi's formula to semi-colons ? SUMIF(C1:C100;"New";D1:D100)

[AliGW]

Not if the OP really is getting an #ERROR! message - when commas need changing to semi-colons, you can't even enter the formula (usually), and you get a pop-up message. The OP needs to clarify.

[EUDIS1980]

Sorry about that.

I just figured out how to post a file instead of a link.
I also understand now that the problem is with Google, because the formula works on MS Excel, but not on Google Spreadsheets.

[AliGW]

In that case, you posted in the wrong forum section. I have moved the thread for you.

I don't work with Google Sheets, so cannot help further myself - sorry.

[EUDIS1980]

It works anyway, because i have the Excel sheet locally and online, so thank you very much for your help

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.