SUMIF pulling from wrong range

rhae52 · Newbie Joined: 08 Jun 2012 Posts: 1

Hi:
I would appreciate any assistance with this issue. I am using a SUMIF() function to find a value from two different sections and the function is pulling results from the wrong range.

The scenerio: There are two sections I need to pull data from based upon a person's name. So the criteria is looking for a name in two different ranges and then adding up the numbers from ranges within the same section that coincide with that name.

SUMIF(A5:A10:A30:A40;"Name";F5:F10:L30:L40)

I used the formula on the previous section and it worked perfectly. But the formula is now pulling the results from a range outside the formula. (i.e. instead of pulling the cell F5 for the result, it is pulling F1).

Is it the formula, an absolute reference issue?

Thank you.

Robert Tucker · Posted: Fri Jun 08, 2012 8:11 am Post subject:

Why not:

=SUMIF(A5:A10;"Name";F5:F10)+SUMIF(A30:A40;"Name";L30:L40)
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

karolus · OOo Advocate Joined: 22 Jun 2011 Posts: 208

Hallo
I wonder why, but this works also:

SUMIF((A5:A10:A30:A40);"Name";(F5:F10:L30:L40))

Karo