DSUM Criteria

**minkus** · 01-30-2010, 08:09 PM

Hello;

I'm trying to write up the criteria for a DSUM equation - the column within data table I'm wanting to sum has numbers stored as text as well as characters - is there a way to set the criteria so that it doesn't add certain numbers stored as text? I tried ="<>3" and <>3; then basically every combination I could think of...

When I set the criteria to ="=3" it will take the sum; can't understand why it'd be any different for a does not equal sign.

Thank you for any help!

Mike

**Richard Buttrey** · 01-30-2010, 08:51 PM

Hello Mike,

Have you tried

="<>"&3

Rgds

**Palmetto** · 01-30-2010, 08:55 PM

Try this - note the single quote just before the numeric character

="<>'3"

**minkus** · 01-30-2010, 09:38 PM

I tried both examples; no luck. Here's a part of the spreadsheet I'm working with for an example; maybe I have weird formatting going on - but this is how I get it back from the query. Thanks guys

**jeffreybrown** · 01-30-2010, 10:07 PM

How about using this...

=SUMPRODUCT(--($D$2:$D$39=$D$46),--($F$2:$F$39=$E$46),--($C$2:$C$39=$F$46),--($J$2:$J$39<>2))

I get an answer of 38.

I will try the DSUM in the meantime...

**darkyam** · 01-31-2010, 12:17 AM

It's not working as is because your 2s in the table are text and the one in the conditions table is a number. If you correct the top table to be numbers, your DSUM will work.