+ Reply to Thread
Results 1 to 3 of 3

excell spread sheet adding rows

  1. 10-19-2007, 01:07 PM #1
    taxswg
    taxswg is offline
    Registered User
    Join Date
    10-19-2007
    Posts
    1

    excell spread sheet adding rows

    i have 3 cells with numbers in them in a 4th cell want to add the other 3 cell but any of the other 3 cell =0 then 4th cell needs to =0
    Reply With QuoteRegister To Reply
  2. 10-19-2007, 01:59 PM #2
    psumvp
    psumvp is offline
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103
    if(min(a1:a3)=0,0,sum(a1:a3))
    Reply With QuoteRegister To Reply
  3. 10-20-2007, 02:05 AM #3
    starguy
    starguy is offline
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    OR

    A better approach if you may have negative numbers in those 3 cells

    =IF(COUNTIF(A1:A3,0),0,SUM(A1:A3))
    starguy

    Tahir Aziz
    PAKISTAN
    https://www.facebook.com/businessexcel
    __________________
    Forum Rules (read before you post)
    Links to the world of Excel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1