OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

SUMIF pulling from wrong range

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
rhae52
Newbie
Newbie


Joined: 08 Jun 2012
Posts: 1

PostPosted: Fri Jun 08, 2012 7:36 am    Post subject: SUMIF pulling from wrong range Reply with quote

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.
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Fri Jun 08, 2012 8:11 am    Post subject: Reply with quote

Why not:

=SUMIF(A5:A10;"Name";F5:F10)+SUMIF(A30:A40;"Name";L30:L40)
_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Fri Jun 08, 2012 8:26 am    Post subject: Reply with quote

Hallo
I wonder why, but this works also:

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

Karo
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group