Results 1 to 4 of 4

Why is #VALUE! appearing

Threaded View

khank Why is #VALUE! appearing 04-09-2011, 04:36 PM
Colin Legg Re: Why is #VALUE! appearing 04-09-2011, 06:15 PM
martindwilson Re: Why is #VALUE! appearing 04-09-2011, 06:42 PM
khank Re: Why is #VALUE! appearing 04-09-2011, 07:40 PM
  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Why is #VALUE! appearing

    I'm looking to SUM the "odd" and "even" numbers.

    In this case below there should be 2 "odd" and 3 "even" numbers.

    N13 8
    O13 5
    P13 0
    Q13 7
    R13 4
    S13 <blank>

    The coding I'm using is:

    For "ODD" in cell T13:
    =SUMPRODUCT(--(MOD(N13:S13,2)=1))

    For "EVEN" in cell U13:
    =SUMPRODUCT(--(MOD(N13:S13,2)=0))-COUNTIF(N13:S13,"")

    This coding was working, now appearing is the terrible "#VALUE!" in both cells. The cell format is "General" on all cells.

    Again I cleared the cells and re-entered the coding – and still the same.

    Any suggestions???
    Last edited by khank; 04-09-2011 at 07:41 PM.

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