SUMIF not adding

**dmad81** · 05-29-2012, 01:43 PM

I'm using Excel 2010 and want to add ONLY the numbers that meet a minimum amount condition. See below.

5654653 (This is $D$2)
654654
766546
565465
65464
32321
23234
1321
343243
7987
79898
46565
=SUMIF(D2:D13,">=$D$2*.0004") This formula is giving a "0" result. AND, the $D$2 cell will not show a colored outline when I dbl-clk on the formula cell.

Thanks for any help on this.
Dave

**jeffreybrown** · 05-29-2012, 01:46 PM

How about

=SUMIF(D2:D13,">="&$D$2*0.0004)

You were almost there, just a quote out of place with the addition of an ampersand.

**dmad81** · 05-29-2012, 01:57 PM

It worked! The fx button/wizard automatically placed the quotes, so I'm not sure if it's working correctly or I did something wrong. Thanks for the help.

Originally Posted by jeffreybrown

How about

=SUMIF(D2:D13,">="&$D$2*0.0004)

You were almost there, just a quote out of place with the addition of an ampersand.

**dmad81** · 05-29-2012, 01:59 PM

What does the "&" do?

**dilipandey** · 05-29-2012, 01:52 PM

Hi dmad81,

You can use the below formula:-

{=SUM(IF($D$3:$D$13>=($D$2*0.0004),D3:D13,""))}

See the attachment:-
SumIf issue.xlsx
regards,
DILIPandey

<click on below 'star' if this helps>

**jeffreybrown** · 05-29-2012, 02:03 PM

The & is just a way of concatenating the >= to the value in D2.

In order to check out what a formula is doing, look at the Evaluate feature >> Formulas Tab >> Evaluate Formula

Place your cursor on the cell and do the above. Now you can evaluate the formula step-by-step and see what is happening.

**dmad81** · 05-29-2012, 02:09 PM

Thanks! I will check it out.

SUMIF not adding

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

SUMIF not adding

Re: SUMIF not adding

Re: SUMIF not adding

Re: SUMIF not adding

Re: SUMIF not adding

Re: SUMIF not adding

Re: SUMIF not adding

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions