Use the dbsum formula with an empty value

[marcvanderpeet12]

Dear all,

I have the following use case:

- I have a dataset that I would like to filter based on value (the value I H2 is my example). Therefore I am using the dbsum formula and a query. One value in the query is customizable so you can quickly get a sum of the different variables. Attached you can find an example with some dummy data.

It all works but the problem is that I also want to be able to filter using a blank value (so I get a sum of all the values). However I cant seem to get a blank value in the query (even though I included a blank value in the list in H2). If I select the empty value of the fruit list now I automatically get a "0" in the query.

Any thoughts how I can work around this?

 

[xlstime]

Very simple just replace your formula (cell e3)

=IF(H2="","",H2)

Dear all,

I have the following use case:

- I have a dataset that I would like to filter based on value (the value I H2 is my example). Therefore I am using the dbsum formula and a query. One value in the query is customizable so you can quickly get a sum of the different variables. Attached you can find an example with some dummy data.

It all works but the problem is that I also want to be able to filter using a blank value (so I get a sum of all the values). However I cant seem to get a blank value in the query (even though I included a blank value in the list in H2). If I select the empty value of the fruit list now I automatically get a "0" in the query.

Any thoughts how I can work around this?

 

[Chihiro]

In this case you can use concatenation.
In E3: =H2&""

 

[marcvanderpeet12]

Totally works guys. Thanks!