Consulting

Results 1 to 3 of 3

Thread: Solved: SUMIF "CELL IS NOT NULL"

  1. 01-11-2009, 02:25 AM #1
    jammer6_9
    jammer6_9 is offline
    VBAX Mentor jammer6_9's Avatar
    Joined
    Apr 2007
    Location
    Saudi Arabia
    Posts
    318
    Location

    Solved: SUMIF "CELL IS NOT NULL"

    =SUMIF(F5:F35,"<>NULL",B5:B35)

    I want to sum a range when it is not null? I tried above formula but still summing all cell ranges.
    T-ogether
    E-veryone
    A-chieves
    M-ore


    One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
    Reply With Quote Reply With Quote
  2. 01-11-2009, 04:33 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    =SUMIF(F5:F35,"<>",B5:B35)
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
  3. 01-11-2009, 05:04 AM #3
    jammer6_9
    jammer6_9 is offline
    VBAX Mentor jammer6_9's Avatar
    Joined
    Apr 2007
    Location
    Saudi Arabia
    Posts
    318
    Location
    I thought I have tried that ... That works!
    T-ogether
    E-veryone
    A-chieves
    M-ore


    One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules