More on SumIf........Totals
More on SumIf........Totals
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: More on SumIf........Totals

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi,

    Earlier today i thought i had it:

    =SumIF(O7:O2000,">0",S7:S2000) But the problem is it works just like it's written as
    it never quits counting

    What i really need is to sum between certain
    rows, and without a defined range i.e.

    O7>1
    O8>1
    O9=0
    Q6=S7:S9(Total)

    O11>1
    O12=0
    O13>1
    O14>1
    Q10=S11:S14(Total)

    So as you can see without a defined range
    i'm at a loss on how to control the total

    any further help on this subject would be
    very much appreciated

    Thanks,Jim

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi James

    Stick to the same feeds that is add to your original feed earlier today - this board SHOULD but it top of the board so people will read and re read your posts else we all get confused...

    Sorry mate i sit hours just like you and many others and ive lost where i was with your post.... im not have gos or moaning JUST want the best responce for YOU so you get the best poss help out there,

    We could have two posts all flying about.

    Im sure you understand - i not picking faults just in case you did not realise.

    Take care friend
    Rdgs
    ==========
    Jack

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-18 14:51, James wrote:
    Hi,

    Earlier today i thought i had it:

    =SumIF(O7:O2000,">0",S7:S2000) But the problem is it works just like it's written as
    it never quits counting

    What i really need is to sum between certain
    rows, and without a defined range i.e.

    O7>1
    O8>1
    O9=0
    Q6=S7:S9(Total)

    O11>1
    O12=0
    O13>1
    O14>1
    Q10=S11:S14(Total)

    So as you can see without a defined range
    i'm at a loss on how to control the total

    any further help on this subject would be
    very much appreciated

    Thanks,Jim
    James, take a look at my response to your original posting...

    =SUMIF(O7:O2000,"<>",S7:S2000)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com