Sumif function does not recognize criteria from a list box.

Question

Hello everyone,

i have a small problem with the sumif function. I have fields in my excel sheet that i fill with list box i have created. Depending on that which word i have chosen, i have to sum some sells. The problem is that the function is working properly only when i type the word manually, otherwise i just get 0 in my sum field. I have already tried many times to change the format of the cells and other things, but it just keeps working properly only if i type the word manually.

Can someone please help me ?

Thanks in advance!

Best regards

Georgi Georgiev.

Answer 1

Have you mannually entered the data validation list or are you using a list located elsewhere in your workbook?

Is the spelling correct in the resource (data validation or list)? Are there any spaces you're not seeing?

If you're using a list - I would add the Index function to the formula.

If you would send  me the workbook - I can take a look.

******@hotmail.com

Cheers.

Answer 2

Hello,

I have found my mistake. It was a "space"after the words- "Bauteil"+" " in the drop down box. I have now deleted it and it works nicely.

Thank you all very much for your attention!!

Answer 3

Below is a picture of my sheet."Typ der Beschaffung "is the drop down box with validation. It has two items-"Bauteile" and "Dienstleistungen". What I want to do, is to automatically sum up all of the Brutto amounts and to know how much I have spent for these two types.

The sumif function I wrote is in the function box. It is for Cell C22.

It works only if I type "Bauteil" or "Dienstleistung" manually. If I choose these from the box, the function just provides a 0.

I hope I have explained it good enough.

Thank you for your help!

Answer 4

Hello,

i am using a drop down validation box. The values are completely identical, from the list box and when i'm typing manually. The values that i have assigned as data for the list box are also type text. This is the same as when i'm typing manually.

Answer 5

Are you using a drop down validation list or a list box control?

If a drop down validation list, are the values in the list the same as you are typing in manually?

Kevin