+ Reply to Thread
Results 1 to 3 of 3

Exclude blanks from formula

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    6

    Exclude blanks from formula

    I have applied this function to a single column with two observations: =SUMPRODUCT(A1:A2;LOG(A1:A2;2)) and it works.

    Now I want to calculte several columns that donīt have the same number of observations but with results displayed on the same row (A$11). I tried to use this formula but it doesnīt seem to work.

    IF(A1:A10>"",SUMPRODUCT(A1:A10;LOG(A1:A10;2)),"")

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,458

    Re: Exclude blanks from formula

    Perhaps
    Please Login or Register  to view this content.
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Exclude blanks from formula

    Hm, it doesnīt seem to work. To clarify: I can use this formula and drag it to other columns if each column contains 10 observations:

    =SUMPRODUCT(A1:A10;LOG(A1:A10;2)).

    However it doesnīt work if each column has different noobs (10 or less).

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1