formula using if and sum is returning false value.

**hpcoolt** · 10-02-2009, 03:19 PM

hi

i have a simple problem that i cannot solve...

can anyone tell me what ivwe done wrong in the formula below..

=IF(D18:D25=123456,SUM(e18:g29))

it is returning a false value

what i want it to do is look for the code 123456 in d18 to d25 and if it finds it add up the sum of columns e18 to g29

any help greatly appreciated

**shg** · 10-02-2009, 03:23 PM

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**hpcoolt** · 10-02-2009, 03:37 PM

hi

i have amended my title. can anyone help me please..i just cant work it out

thankyou

claire

**Dave H** · 10-02-2009, 03:43 PM

You should be using the sumif function if I understand your question.

**keith6292** · 10-02-2009, 06:19 PM

=sumif(range,critiera,sum_range)
=sumif(D18:D25,123456,E18:G29)

I think that will work.

formula using if and sum is returning false value.

LinkBack

Thread Tools

Rate This Thread

Display

formula using if and sum is returning false value.

Re: formula returning false value ...not sure what i have done wrong

Re: formula using if and sum is returning false value.

Re: formula using if and sum is returning false value.

Re: formula using if and sum is returning false value.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions